note 23830 added to function.date
| From: | eli@php.net | Date: | Mon, 29 Jul 2002 19:58:32 +0000 |
| Subject: | note 23830 added to function.date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-33889@lists.php.net to get a copy of this message | ||
if you are using MySQL timestamp format, you should try this when seleceting a line:
SELECT *,DATE_FORMAT(timestamp, '%d-%M-%y %H:%i') AS time FROM table
as you select, you will be added another field under the name time with the wanted format.
for more info about the format, fo here:
http://www.mysql.com/doc/D/a/Date_and_time_functions.htm
--
http://www.php.net/manual/en/function.date.php
http://master.php.net/manage/user-notes.php?action=edit+23830
http://master.php.net/manage/user-notes.php?action=delete+23830
http://master.php.net/manage/user-notes.php?action=reject+23830