Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem:
I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have exported the filemaker records as tab delimited files and have managed to load them in to MySQL without too much problem. However I have one issue: Dates. Of course MySQL stores dates in YYYY-MM-DD whilst filemaker uses DD-MM-YYYY and so when I import my delimited text file MySQL interprets the dates incorrectly. I can't seem to find a way of changing the date format in Filemaker, nor can I figure out how to get MySQL to convert the dates into it's format. Any help would be greatly appreciated and I apologise if this is something simple but this is my first entanglement with databases. I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was compiled from the FreeBSD port. Thanks for your help, Cameron --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php