2 start and 2 end dates difference. sql server
I have 4 dates. For example.
2 start dates and 2 end dates, like:
Start_Date_HE 2013-08-15 01:24:00.000
End_Date_HE 2013-08-15 02:09:00.000
and
Start_Date_Lunch
2013-08-14 20:40:00.000
End_Date_Luch
2013-08-14 21:40:00.000
I wanna know hou many minutes i have between these dates.
In this sample is might be 0. because 20:40 until 21:40 is not between
01:24 until 02:09
No comments:
Post a Comment