Date difference in sql / Datediff in SQL

Find Datedifference in SQL

     Datediff is used to find the difference between two dates.

Syntax

datediff(Interval,convert(date,Date1),convert(date,Date2)) as DiffDay

Example

select datediff(DAY,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay

Interval

• HOUR
• SECOND
• MINUTE
• DAY
• MONTH
• YEAR

Hour

     Show the difference in Hour.

select datediff(HOUR,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay

Second

     Show the difference in Seonds.

select datediff(SECOND,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay

Minute

     Show the difference in Minutes.

datediff(MINUTE,convert(date,Date1),convert(date,Date2)) as DiffDay

Day

     Show the difference in Day.

select datediff(DAY,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay

Month

     Show the difference in Month.

select datediff(MONTH,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay

Year

     Show the difference in Year.

select datediff(YEAR,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay