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 |
|
eddie
Starting Member
45 Posts |
 Posted - 2002-04-23 : 13:37:40
|
| I have a bunch of data in an excel spreadsheet. Like124511214451212etc.This data represents 'minutes after midnight' I need to write a statement to convert these numbers to an actual time. Any suggestions? ALso, when I import it into sql server, what type of datatype should I convert it to? Numeric, int?Thanks,Eddie |
|
|
jbkayne
Posting Yak Master
100 Posts |
Posted - 2002-04-23 : 14:06:18
|
| 1st Question:I would convert it to the actual time in a UDF.Here is the formula I would use.select convert(char(12),dateadd(mi, 121, '00:00:00.000'),114)2nd Question: Int (if it is minutes only and not seconds)Edited by - jbkayne on 04/23/2002 14:07:32 |
 |
|
|
|
|
|
datetime functions..