Re: TIMESTAMP -> Y-m-d
| From: | Sean Burlington | Date: | Thu, 05 Jun 2003 07:57:41 +0000 |
| Subject: | Re: TIMESTAMP -> Y-m-d | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28342@lists.php.net to get a copy of this message | ||
nabil wrote:
Please help me how to print a timestamp string retrived from the database, and print it as YYYY-MM-DDuse the mysql date_format fumction DATE_FORMAT(date,format) select date_format(date_field, '%Y-%m-%d') from data; see the mysql docs for more details -- Sean