Find closest date in SQL Server

by

The where clause will match all rows with date less than @CurrentDate and, since they are ordered descendantly, the TOP 1 will be the closest date to the current date.

SELECT TOP 1 *
FROM x
WHERE x.date < @CurrentDate
ORDER BY x.date DESC

More Related Contents:

  1. How to return only the Date from a SQL Server DateTime datatype
  2. Best approach to remove time part of datetime in SQL Server
  3. Get the week start date and week end date from week number
  4. How to determine the number of days in a month in SQL Server?
  5. Difference between datetime and timestamp in sqlserver? [duplicate]
  6. Query comparing dates in SQL
  7. SQL SERVER: Get total days between two dates
  8. SQL “between” not inclusive
  9. Date serial in SQL?
  10. Convert text to system date format [duplicate]
  11. How to get a particular preceding value of a column in SQL [closed]
  12. How to select just the row in the second table?
  13. SQL update from one Table to another based on a ID match
  14. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  15. SQL JOIN vs IN performance?
  16. Generate SQL Create Scripts for existing tables with Query
  17. SQL Server 2005 How Create a Unique Constraint?
  18. Check if a row exists, otherwise insert
  19. Export SQL query data to Excel
  20. Alter user defined type in SQL Server
  21. Deferrable Constraints in SQL Server
  22. What does sp_reset_connection do?
  23. SQL Server equivalent to MySQL enum data type?
  24. How to correctly insert newline in nvarchar [duplicate]
  25. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  26. SELECT max(x) is returning null; how can I make it return 0?
  27. How to return default value from SQL query
  28. Group consecutive rows of same value using time spans
  29. Conditional aggregation performance
  30. SQL add filter only if a variable is not null

Leave a Comment