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.
OK, I'll add that to my experiments to do list. In the meantime, I imported all the dates as VARCHAR, then went into phpMyAdmin and changed it to DATE. It seems to work!
Thanks again for the tips.
Oh, one other thing... Do you know if dates can be sorted in various ways, either by absolute date or by month alone, date alone, etc.? I'm going to be making sortable columns (JavaScript or PHP), and I'm not yet sure what all you can do with dates.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
