Compare and find difference in DateTime Column Fields in Minutes in SQL Server

Question

i want compare two datetime and find minutes in sqlEmampleDate 1 10222014 200000000Date 2 10222014 230000000then i want output like this180 minutesHow can possible

EmadKhan · Accepted Answer

Do this  Syntax DATEDIFF  datepart  startdate  enddate  Example usageSELECT DATEDIFFDAY GETDATE GETDATE  1 AS DayDiffSELECT DATEDIFFMINUTE GETDATE GETDATE  1 AS MinuteDiffSELECT DATEDIFFSECOND GETDATE GETDATE  1 AS SecondDiffSELECT DATEDIFFWEEK GETDATE GETDATE  1 AS WeekDiffSELECT DATEDIFFHOUR GETDATE GETDATE  1 AS HourDiff In your question it will be like this  SELECT DATEDIFFMINUTE 3910222014 20000000039 3910222014 23000000039 AS MinuteDiffOutput  180

Azim · Answer

SQL DECLARE  Table TABLEDate1 DATETIME Date2 DATETIMEINSERT INTO Table VALUES3910222014 200000000393910222014 23000000039SELECT DATEDIFFMINUTE Date1 Date2 AS DiffInMinFROM Table

Compare and find difference in DateTime Column Fields in Minutes in SQL Server

Company

Explore

Follow us

Contact Us