ahhh, tis quite simple my friend.
that number represents the amount of seconds since jan 1, 1970.
<cfset nowSeconds = dateDiff('s','01-01-1970 00:00:00.000',now())>
or to go back the other way...
<cfset dateNow = dateAdd('s','01-01-1970 00:00:00.000',1061550930)>
i may have the parameters a bit effed up, but you should get the
picture.
hth
tony
-----Original Message-----
From: B.H. Forbes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 8:14 PM
To: CF-Talk
Subject: DATE conversion msAccess to mySQL
My cold fusion forum software (using msAccess) has finally buckled under
the
heavy loads...
I need to convert my existing msAccess data to another forum package
that
uses mySQL.
I am able to convert all existing data except for any DATE field.
All dates in the msAccess db are stored as Date/Time.
The DATE fields in the mySQL database however are setup as INT(10)
(huh?? looks like (but I know it isn't) a gregorian or julian date).
Typical values in the mySQL database of exisiting data are:
1061505830, 1061506894, 1061509575, 1061550930
MsAccess has the standard date/time values:
4/11/2003 3:56:58 AM, 7/7/2002 12:04:16 PM, etc.
I have tried a bazillion CF functions trying to get that msAccess date
to
convert properly... so many that now my fingers have lost their
fingerprints, my eyes are blurred, and I cannot feel my legs anymore.
Can someone help me or... should I just start mowing lawns for a living?
(10,000 usernames, and 400,000 messages to export from msAccess ot mySQL
-
ugh).
-pat-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
