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 - 2006-05-11 : 08:21:54
|
| Jay writes "hi i need to convert decimal to minutes. for example:I have values as.150000.300000.9000002.7000006.3000009.30000011.70000028.80000036.15000086.700000595.5000001652.850000How to convert them into Minutes? Please help me" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-11 : 08:29:16
|
| select hrs = convert(int,fld), mins = 60.0 * (fld - convert(int,fld))from tbl==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Convert