RE: [PHP-DB] Date format problem
| From: | Jennifer Goodie | Date: | Wed, 13 Aug 2003 01:14:43 +0000 |
| Subject: | RE: [PHP-DB] Date format problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29860@lists.php.net to get a copy of this message | ||
>
> I have a field in my mysql db wich is a timestamp with the format
>
> yyyymmddhhmmss
>
> and I would like to display it like:
>
> dd/mm/yyyy
>
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333
SELECT DATE_FORMAT(timestamp_col_name, '%d/%m/%Y') FROM table_name