SQL time-related-SQL date, time comparison

Time comparison in SQL Server

Example:

Select COUNT (*) from table where DATEDIFF ([second], ' 2004-09-18 00:00:18 ', ' 2004-09-18 00:00:19 ') > 0

Description

　　Select DATEDIFF (Day, time1, time2) corresponds to the following example statement

Select DATEDIFF (Day, ' 2010-07-23 0:41:18 ', ' 2010-07-23 23:41:18 ')

　　time1 > time2 is negative;

　　Time1 < time2 are positive;

　　[Day]: will only compare 2010-07-23 ignored 0:41:18 ' Other empathy

The following distinctions:

　　Year: SELECT DATEDIFF ([year],time1, time2) returns the value:-6, which indicates that the inverse of the post-subtraction is contrary to MySQL.

　　Month: SELECT DATEDIFF ([month], time1, time2)

　　Days: SELECT DATEDIFF ([day], time1, time2)

　　Hours: SELECT DATEDIFF ([hour], time1, time2)

seconds: SELECT DATEDIFF ([second], time1, time2)

SQL time-related-SQL date, time comparison