> 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)
It's just a numeric date representation which cf uses ( integer part is
days, rest is numeric for HHMMSSMS)
create a "numeric" date (just add the value 0 to the datefunction)
<cfset dtNow = 0+now()> <!--- just add 0 to the datefunction to get
the numeric date --->
<cfset dtSoon = 0+dateAdd("h", +2, now())>
<cfset dtSomeTimes = 0+createDate(2002, 02, 18)>
you can use normale date display functions for the "numeric date":
#lsdateFormat(dtSoon, "dd.mm.yyyy")#
#dateFormat(dtSoon, "mm/dd/yyyy")#
or just #dateFormat(dtNow)#, #createODBCDate(dtNow)# and more.
int(0+now()) ---> today (only as a day with time = 00:00:00.000)
tomorrow:
1+now() --> integer part is days from 1.1.1900 (?)
--
Hendrik Kramer <[EMAIL PROTECTED]>
Projektleiter Web Applications [VRG E-Solution]
VRG - Vereinigte Rechenzentren GmbH
Mittelkamp 110-118 , 26125 Oldenburg
Tel. (0441) 3907-178 | Fax (0441) 3907-6178
http://www.e-solution.vrg.de/
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
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.
