Hello
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).
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.
Karam
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw