On Tue, Aug 20, 2002 at 04:40:25PM -0400, Serge Paquin wrote: > This is the only option? That's not a very automated >process and I must import this data once a day. I also will >not be able to get them to reformate their data since I'm >only one of many many people downloading everyday. Is their >no way for load data to do this automaticaly?
Paul DuBois has some useful scripts to convert dates in the "Early release software" section of the page for his forthcoming _MySQL Cookbook_ at http://www.kitebird.com/mysql-cookbook/ I think you'll find it pretty useful for this. Jesse Sheidlower --------------------------------------------------------------------- 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