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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2006-08-23 : 08:46:41
|
| HiI have store minutes in numeric field in a table (Totmin)Now i want to convert it into hour & minutesEx: Totmin - 114 result : 1 hours 54 minutesHow can i get it through SELECT statementThanksASM |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-23 : 08:49:34
|
| [code]Select Convert(varchar(10),114/60) + ' Hour ' + Convert(varchar(10),114%60) + ' Minutes '[/code]Chirag |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-23 : 13:03:22
|
| Why dont you use proper DateTime datatype?MadhivananFailing to plan is Planning to fail |
|
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-08-23 : 14:27:26
|
| If the data is something like "total elapsed minutes", why should it be stored with datetime datatype? |
|
|
|
|
|
|
Timediff