Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-20 : 17:36:53
|
| kfir writes "Hello !I wonder if there is a way to find the diffrence between 2 date in minutes.NOT just the minutes field (as DATEDIFF function does),but the entire diffrence -> translated to minutes.thanks kfir" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-20 : 18:21:28
|
| kfir I'm pretty sure DATEDIFF actually does what you want.egSELECT DATEDIFF(n,CONVERT(datetime,'20-Jan-2002 09:41:00'),CONVERT(datetime,'21-Jan-2002 09:43:00'))returns 1442Are you sure you're using "n" or "mi" for the datepart?I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
nricardo
Starting Member
17 Posts |
Posted - 2002-01-22 : 12:01:47
|
| Take the datediff in seconds and divide by 60. |
|
|
|
|
|
|
times on sql