insert into log_book values (TO_DATE('08/12/1973','MM/dd/YYYY'),'C150','N5787G',1,1.8);
would like
insert into log_book values (STR_TO_DATE('08-12-1973','%m-%d-%Y'),'C150','N5787G',1,1.8);
according to the manual, STR_TO_DATE is not until 4.0...I have 3.23.52
hate to write a program to change the format on 500 insert statements
any suggestions
_________________________________________________________________
Enjoy the holiday season with great tips from MSN. http://special.msn.com/network/happyholidays.armx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
