TO: Tony Weeg yep, a little off on the order of the parms but yeah baby... this bad boy is working.... finally, I get to get some sleep...
thanks a bunch. -pat- -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 11:07 PM To: CF-Talk Subject: RE: DATE conversion msAccess to mySQL 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? 10000 usernames,400000 messages to export from msAccess to 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
