SQL time-SQL Date and Time Comparison

Time Comparison in SQL Server

Example:

Select count (*) from table whereDatediff
([Second], '2017-09-18 00:00:18 ', '2017-09-18 00:00:19 ')
> 0

Description

The example statement for select datediff (day, time1, time2) is as follows:

Select datediff (day, '2017-07-23 0:41:18 ', '2017-07-23 23:41:18 ')

time1> time2 is a negative number;

time1 time2 is a positive number;

[ > day ]: Only 2010-07-23 ignore 0:41:18 '>

See the following:

Year:Select datediff ([year],Time1, time2)

Return Value:
-6
, Meaning before Subtraction

And
MySQL
On the contrary.

Month:Select datediff ([month],Time1, time2)

Day:Select datediff ([Day],Time1, time2)

Hours:Select datediff ([hour],Time1, time2)

seconds: select datediff ([second], time1, time2 )