Hi all,
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. The command
I am using is
INSERT INTO TABLE
(QID,REV,DATE)
VALUES
(619 , 12 , 1/4/2001);
I am using phpMyAdmin with the above
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 be any
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