newbie needs to format time field
| From: | Eric J Schwinder | Date: | Mon, 03 Sep 2001 19:39:19 +0000 |
| Subject: | newbie needs to format time field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12126@lists.php.net to get a copy of this message | ||
This may be a dumb question but here goes:
I have a mySQL database that I am using PHP to interface with. I have
fields in the database that are DATE and TIME types. Can I format these
values so that the user sees "September 15, 2001" or "2:00 PM" instead of
"2001-09-15" and "14:00:00" when I show the values on the web page?
If so, can anyone suggest a reference which will help me do this? I didn't
find anything in the mySQL or PHP manuals, but maybe I was looking in the
wrong places! Thanks in advance from a relatively new PHP user!
Eric J Schwinder
eric.AT.bergencomputing.DOT.com