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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Decimal date value

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:

131337246
131337246
131204875
131337246
131337246
131204876

Could someone help me out/point in the right direction as to

a) how to read this value and
b) 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 Larsson
Helsingborg, Sweden
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -