Date & Time Formatting ??
| From: | Jack Sasportas | Date: | Tue, 08 May 2001 16:28:12 +0000 |
| Subject: | Date & Time Formatting ?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-51927@lists.php.net to get a copy of this message | ||
OK I have read many examples, old posts etc, but I am looking for a
detailed explanation as to how to do this.
First is when I write to a mysql database using the now() function, the
time stamp looks like so when I display the time back to the browser.
204:24:06 ( This should have been 12:24pm )
Also the Date Display like so:
2001-05-08
The Goal is to have the Time stamp looking like 12:24 (military time OK)
and the date 05-08-2001 or even 05-08-01.
The MySQL db looks like so:
date 0000-00-00
time 00:00:00
I don't seem to really be able to vary the DB format.
Any examples or links to good docs appreciated....
Thanks...