Patrick Shoaf <[EMAIL PROTECTED]> wrote: > I have a question, when loading dates into mysql I have found I can always > use YYYYMMDD or YYYY-MM-DD, but frequently I need to load data from ASCII > csv files where the date is M/D/YYYY. Currently, I am using perl to read > the datafile and insert each record after converting the date data. I > would prefer to be able to use 'LOAD FROM INFILE', but the dates do not > convert correctly. Is there any way to use the data in M/D/YYYY format?
Nope, if you want to store as a DATE type. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]