Thanks John for the idea... will use php to extract and reparse the
values in the correct order...
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 5:11 PM
To: Aleks @ USA.net; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] inserting date
From: "Aleks @ USA.net" <[EMAIL PROTECTED]>
> I have a large text file that I am inserting into a mysql db and seem to
> have a problem with
> the date format. The data is currently in the mm/dd/ format.
MySQL expects a MMDD or -MM-DD format (the delimiter for the string
version can b