RE: [PHP] Mysql date format
| From: | John W. Holmes | Date: | Fri, 08 Nov 2002 00:26:28 +0000 |
| Subject: | RE: [PHP] Mysql date format | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-123285@lists.php.net to get a copy of this message | ||
> I'm using php with MySql.
> I'm migrating an php-oracle application to php-mysql. I need to know
if
> exists any function in mysql similar to the "to_char" or "to_date"
> functions
> of oracle; or "format" function of access?. These functions make a
date
> format or numeric format.
>
> ex: to_char(sysdate,'dd/mm/yyyy hh:mi:ss') return a string with the
> actual
> datetime in the specified format.
MySQL has the DATE_FORMAT() function to do this.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
#Date_and_time_functions
---John Holmes...