Microsoft Logo

Microsoft SQL Sample Code

DateDiff Function

The DateDiff function is a powerful SQL function you can use to manipulate and work with dates. For example, you may want to find the difference between two dates in the number of days, hours, minutes, etc. The example scripts below will show you how to find specific intervals between dates.

Unit of time Query Result

NANOSECOND SELECT DATEDIFF(NANOSECOND,'2018-12-01 17:15:22.5500000','2018-12-01 17:15:22.55432133') 4321300

MICROSECOND SELECT DATEDIFF(MICROSECOND,'2018-12-01 17:15:22.5500000','2018-12-01 17:15:22.55432133') 4321

MILLISECOND SELECT DATEDIFF(MILLISECOND,'2018-12-01 17:15:22.004','2018-12-01 17:15:22.548') 544

SECOND SELECT DATEDIFF(SECOND,'2018-12-01 17:15:30','2018-12-01 17:16:23') 53

MINUTE SELECT DATEDIFF(MINUTE,'2018-12-01 18:03:23','2018-12-01 17:15:30') -48

HOUR SELECT DATEDIFF(HH,'2018-12-01 18:03:23','2018-12-01 20:15:30') 2

WEEK SELECT DATEDIFF(WK,'09/23/2018 15:00:00','12/11/2018 14:00:00') 12

DAY SELECT DATEDIFF(DD,'09/23/2018 15:00:00','08/02/2018 14:00:00') -52

DAYOFYEAR SELECT DATEDIFF(DY,'01/01/2018 15:00:00','08/02/2018 14:00:00') 213

MONTH SELECT DATEDIFF(MM,'11/02/2018 15:00:00','01/01/2018 14:00:00') -10

QUARTER SELECT DATEDIFF(QQ,'01/02/2018 15:00:00','08/01/2018 14:00:00') 2

YEAR SELECT DATEDIFF(YY,'01/02/2013 15:00:00','01/01/2018 14:00:00') 5

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.