Karam Chand <[EMAIL PROTECTED]> wrote: > Is there anyway to change the default date format > (possibly in a .ini or .cfg file) from YYYY-MM-DD to > another format ? (ie, mm/dd/yyyy or any user-defined > format).
No, You can't. > > The useage that I'm looking at is to import a CSV file > into a table (using Load data infile .... command) > where dates are stored in mm/dd/yyyy format and can > change based on the source of the data. I can import > the date fields into a char field and then convert it > but would like to save the time to transform and copy > contents into another table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
