Thanks Spike,
It explains a lot . But how do I turn a normal date Time like {ts
'2002-02-19 16:40:11'} into a a 37237.487905100 type (or do I just count
the days ?)
Thanks again
Regards
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
-----Original Message-----
From: Spike [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 16:31
To: Spectra-Talk
Subject: RE: Date Time in Spectra
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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
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.
