Re: Date format in MySQL
| From: | rolf vreijdenberger | Date: | Mon, 03 Feb 2003 23:09:02 +0000 |
| Subject: | Re: Date format in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25384@lists.php.net to get a copy of this message | ||
the function you need is
DATE_FORMAT()
select event, DATE_FORMAT(my_time,'%d-%m-%Y) as mytime From mytable;
mytime will be in the form dd-mm-yyyy, the %d specifier will give you the
prefferred output