At 23:45 +0100 5/29/02, Cameron Murdoch wrote: >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.
http://www.kitebird.com/mysql-cookbook/ One of the scripts in the "early release" distribution is cvt_date.pl. Looks for dates in one format, converts them to another. Might help you out. > >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