November 2, 2010 at 4:43 am
How do i calculate the time difference in minutes between these two columns?
Is it as....? SELECT DATEDIFF(mm,[Planned Start Time], [Actual Start Time])
Planned Start Time Actual Start Time
1899-12-30 09:00:00.0001899-12-30 09:20:00.000
1899-12-30 09:00:00.0001899-12-30 09:09:42.000
1899-12-30 09:00:00.0001899-12-30 10:02:59.000
1899-12-30 09:00:00.0001899-12-30 09:00:59.000
November 2, 2010 at 4:46 am
Yes, exactly as that. Except "mm" should be either "mi", "n" or "minute".
Using "mm" gives you 0 as result because "mm" denotes difference in months [boundary crossings].
"mi", "n" or "minute" gives you the result in minutes.
N 56°04'39.16"
E 12°55'05.25"
November 2, 2010 at 4:49 am
perfect... thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply