Re: Question About Date Function in PHP/MySQL
| From: | John W. Holmes | Date: | Mon, 09 Feb 2004 17:05:08 +0000 |
| Subject: | Re: Question About Date Function in PHP/MySQL | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177147@lists.php.net to get a copy of this message | ||
Freedomware wrote:
EMS lists the following: Short Date: M/d/yyyy Long Date: dddd, MMMM dd, yyyy Day followed by month, followed by another day, then year???That format means something like "Friday, May 5, 2004"
I thought it was supposed to be year first, followed by month and day, as in the example from CSV table - 1905-09-01. Should I change Long Date so that it reads YYYY-MM-DD, or something like that?Yeah, I'd try switching possibly both the long and short dates to YYYY-MM-DD and see if it's imported correctly. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com