Re: formatting date issues
| From: | John W. Holmes | Date: | Tue, 04 May 2004 13:08:13 +0000 |
| Subject: | Re: formatting date issues | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-185304@lists.php.net to get a copy of this message | ||
From: "Travis Low" <travis@dawnstar.com>
> The database is returning the dates in standard SQL format. Use date():
>
> <?php echo date( "F j, Y", strtotime( $row_rsNewsDate['date'] ) )
> ?>
>
> http://www.php.net/manual/en/function.date.php
Or use DATE_FORMAT() to format the dates in your query before they're
returned.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
---John Holmes...