Forum Discussion
datetime difference as decimal number
HI all, I need a column to calculate datetime difference between two datetime columns, enddate - startdate. Both columns are in this format 7/19/2018 8:31:00 AM I will add conditional colu...
Hi there,
I think DATEDIFF can handle negative numbers now, DATEDIFF(startdate, enddata, HOUR) should work.
The other way of doing this would be to calculate:
(enddate - startdate) * 24 for hour,
(enddate - startdate) * (24 * 60) for minutes,
(enddate - startdate) * (24 * 60 * 60) for seconds.Best regards,
Kristjan
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense.If not, please share more details about your issue so that we could help further on it.
Regards,
Cherie