They are the time in days since 1900. You can convert them to a date as
follows:
dateadd('d',0,thisdate)
Spike
-----Original Message-----
From: Russell Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 3:08 PM
To: Spectra-Talk
Subject: Date Time in Spectra
Hi,
When querying the codb all dates come back as 37237.656307900 type strings.
I can turn these into regular date time objects with
DateConvert("utc2local",37237.656307900) but cannot turn a normal date
object to 37237.656307900 type date with DateConvert("local2utc",now()). Any
idea what sort of dates these 37237.656307900 type dates are, and how best
to work with them ? Are they Roman, Gregorian, Julien or wtf are they ?
Any CF functions for working with these dates (particularily turning Now()
into a 37237.656307900 type date, would be very very cool)
Thanks in Advance
Russell
--------------------------------------------
Freeserve Production: Turning Ideas Into Reality
Russell Brown
Internet Application Developer
Freeserve.com Plc, PO Box 452, Leeds LS2 7EY
Never pay another Internet phone bill!
Freeserve AnyTime, for all the Internet access you want, day and night, only
12.99 per month.
Sign-up at http://www.freeserve.com/time/anytime
______________________________________________________________________
Macromedia ColdFusion 5 Training from the Source
Step by Step ColdFusion
http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
