note 23830 deleted from function.date by sniper
| From: | sniper@php.net | Date: | Sat, 11 Oct 2003 16:50:18 +0000 |
| Subject: | note 23830 deleted from function.date by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-58261@lists.php.net to get a copy of this message | ||
Note Submitter: eli {@} the-ace.ws
----
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/en/Date_and_time_functions.html