How to compare two dates to find time difference in SQL Server 2005, date manipulation

by

Take a look at the DateDiff() function.

-- Syntax
-- DATEDIFF ( datepart , startdate , enddate )

-- Example usage
SELECT DATEDIFF(DAY, GETDATE(), GETDATE() + 1) AS DayDiff
SELECT DATEDIFF(MINUTE, GETDATE(), GETDATE() + 1) AS MinuteDiff
SELECT DATEDIFF(SECOND, GETDATE(), GETDATE() + 1) AS SecondDiff
SELECT DATEDIFF(WEEK, GETDATE(), GETDATE() + 1) AS WeekDiff
SELECT DATEDIFF(HOUR, GETDATE(), GETDATE() + 1) AS HourDiff
...

You can see it in action / play with it here

More Related Contents:

  1. Get the week start date and week end date from week number
  2. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. The multi-part identifier could not be bound
  5. Fastest way to update 120 Million records
  6. Is it possible to select sql server data using column ordinal position
  7. How to find current transaction level?
  8. How to insert multiple records and get the identity value?
  9. How do you do date math that ignores the year?
  10. How can a LEFT OUTER JOIN return more records than exist in the left table?
  11. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  12. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  13. SQL comma-separated row with Group By clause
  14. How to calculate the number of “Tuesdays” between two dates in TSQL?
  15. How to copy a huge table data into another table in SQL Server
  16. How to split string using delimiter char using T-SQL?
  17. Should I use SQL_Variant data type?
  18. SQL server select distinct rows using most recent value only
  19. Script to save varbinary data to disk
  20. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  21. How to select date without time in SQL
  22. What is the internal representation of datetime in sql server?
  23. Eliminate and reduce overlapping date ranges
  24. Postgresql query between date ranges
  25. What does collation mean?
  26. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  27. SQL Sort Order with Null values last
  28. SQL Query for Parent Child Relationship
  29. Insert all values of a table into another table in SQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment