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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-07-07 : 04:14:44
|
| how can I convert a number of minutes to a datetime (to be inserted in a database in a datetime field)like 130 should go in as 2:10:00 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-07 : 04:43:10
|
select convert(char(8), dateadd(minute, 130, '00:00:00'), 108)
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-07 : 04:43:15
|
dateadd(minute, 130, 0)
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-07-07 : 05:43:26
|
| thanks :) |
|
|
|
|
|
|
convert minutes to datetime field