CODEWITHSUNDEEP
timesql-server-2012seconds
Sabi Tech
Sabi Tech

Reputation: 81

SQL Difference between two times in seconds

SELECT   Warehouses.Name,
         RIGHT(CONVERT(VARCHAR,AirwayBillTrucks.CheckOutTime,100),7) AS CheckOutTime,
         RIGHT(CONVERT(VARCHAR,AirwayBillTrucks.ReturnTime,100),7) AS ReturnTime

That is my piece of code, CHECKOUTTIME and RETURNTIME used to be DATETIME DD-DD-YYYY HH-MM-SS but I converted them into TIME HH-MM-SS tt which is fine for me. Now I need to now the difference between those two columns in seconds,

Upvotes: 2

Views: 4434

Answers (1)

Sam
Sam

Reputation: 910

SELECT DATEDIFF(ss,CheckOutTime,CheckInTime)

Upvotes: 4

Related Questions