Format the date as used in MySQL?
| From: | Todd Eddy | Date: | Fri, 19 May 2000 04:46:47 +0000 |
| Subject: | Format the date as used in MySQL? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-172@lists.php.net to get a copy of this message | ||
I am trying to format the datestamp that is created in MySQL and it
doesn't seem to work. For example, in MySQL, the datestamp is shown as
20000515101054 (yyyymmddhhmmss) but when I use date( "F d, Y", $date )
where $date is what I have that entry saved as, I get January 13, 2038.
Is there a different command to handle these kind of dates or do I have
to format it some way? BTW, I also wanted to include the time, but just
wanted to check it quickly, so I don't know how the time will show up.
--
Todd Eddy
tristar@raex.com
http://www.vrillusions.com/