Difference of two date time in sql server

by

Just a caveat to add about DateDiff, it counts the number of times you pass the boundary you specify as your units, so is subject to problems if you are looking for a precise timespan.
e.g.

select datediff (m, '20100131', '20100201')

gives an answer of 1, because it crossed the boundary from January to February, so even though the span is 2 days, datediff would return a value of 1 – it crossed 1 date boundary.

select datediff(mi, '2010-01-22 15:29:55.090' , '2010-01-22 15:30:09.153')

Gives a value of 1, again, it passed the minute boundary once, so even though it is approx 14 seconds, it would be returned as a single minute when using Minutes as the units.

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to return only the Date from a SQL Server DateTime datatype
  3. Best approach to remove time part of datetime in SQL Server
  4. DateTime2 vs DateTime in SQL Server
  5. SQL query to select dates between two dates
  6. How to combine date from one field with time from another field – MS SQL Server
  7. How can I select the first day of a month in SQL?
  8. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  9. How to convert DateTime to VarChar
  10. Get day of week in SQL Server 2005/2008
  11. T-SQL: Round to nearest 15 minute interval
  12. SQL Server Convert Varchar to Datetime
  13. How Can I use “Date” Datatype in sql server?
  14. How to determine the number of days in a month in SQL Server?
  15. Calculate business hours between two dates
  16. SQL Server convert string to datetime
  17. How do I query for all dates greater than a certain date in SQL Server?
  18. A way to extract from a DateTime value data without seconds
  19. How can I compare time in SQL Server?
  20. Custom Date/Time formatting in SQL Server
  21. How to compare datetime with only date in SQL Server
  22. Getting Dates between a range of dates
  23. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  24. What is the internal representation of datetime in sql server?
  25. SQL SERVER DATETIME FORMAT
  26. How do I delete from multiple tables using INNER JOIN in SQL server
  27. Does Foreign Key improve query performance?
  28. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  29. What does ON [PRIMARY] mean?
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment