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?
Patrick J. Shoaf, Systems Engineer
<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
Midmon Internet Services, LLC
100 Third Street
Charleroi, PA 15022
http://www.midmon.com
Phone: 724-483-2400 ext. 105
or 888-638-6963
Fax: 724-489-4386
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]