SQL Server

DATEDIFF() Function in SQL Server



 Like (0)  Dislike (0)

The DATEDIFF() function returns the difference between two dates.

  1. SELECT DATEDIFF(year, '2010/08/25','2015/08/25') AS DateDiff;  
  2.   
  3. SELECT DATEDIFF(month, '2010/08/25 10:40:30','2015/08/25 10:40:30') AS DateDiff;  
  4.   
  5. SELECT DATEDIFF(n, '2010/08/25 10:40:30','2015/08/25 10:40:30') AS DateDiff;  
  6.   
  7. SELECT DATEDIFF(ss, '2010/08/25 10:40:30','2015/08/25 10:40:30') AS DateDiff;  

0 Comment's

Comment Form

Submit Comment
If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example