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 |
cblatchford
Starting Member
40 Posts |
Posted - 2007-07-12 : 09:52:05
|
Hi experts,I have a decimal date column with values such as:131337246131337246131204875131337246131337246131204876Could someone help me out/point in the right direction as to a) how to read this value andb) how to convert back to datetime?The field is of type decimal (18,0)ta very much..blatch |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-12 : 15:20:51
|
Most probably they are some kind of offset in {milliseconds, seconds, minutes} from a base date.Peter LarssonHelsingborg, Sweden |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-12 : 15:43:50
|
Do you know the actual date and time those values correspond to?CODO ERGO SUM |
|
|
|
|
|