CODEWITHSUNDEEP
sql-serversql-date-functions
vani
vani

Reputation:

how to get diff b/w 2 columns which is in time format

I've 2 columns called record time and unload time which is in time format AM/PM and I require a new column called total time where I need to find difference between unload time and record time...

for example here is my table

record time  unload time
11:37:05 PM  11:39:09 PM
11:44:56 PM  1:7:23 AM

For this I require a new column which finds the difference between these 2 columns.

Cab anyone suggest a query for this please?

Upvotes: 0

Views: 204

Answers (2)

user114600
user114600

Reputation:

If you're doing timespan calculations within one 24 hour period, anishmarokey's response is correct. However, I'd add the date to the time field as well, if you're going to have cases where the load and unload might occur over midnight between two or more days.

Upvotes: 0

anishMarokey
anishMarokey

Reputation: 11397

why you cant go with datediff system function in SQL SERVER

select  datediff(mi,'11:37:05 PM','11:39:09 PM')

mi/n is for minute

Upvotes: 1

Related Questions