INSERT DATE using USA Date Format

[Michael J. Pawlowsky]

I have some data where the date is already in USA format (MM-DD-YYYY).
I would like to be able to insert this data without having to massage
the date in the code.

Is there a way to specify the Date Format for an INSERT statement?

Something like:

 INSERT INTO tblMyTable(myDate) VALUES(DATE_FORMAT('USA', '12-31-2004');


Thanks,
MIke





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]