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
