Re: time and timestamp
| From: | Burhan Khalid | Date: | Tue, 30 Aug 2005 13:29:34 +0000 |
| Subject: | Re: time and timestamp | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-221589@lists.php.net to get a copy of this message | ||
Jay Blanchard wrote:
[snip] Now I am not worried about the time but I would like to know how to (i) sort the returned rows in order (latest first)add ORDER BY
yourdatefield DESC to your SQL
(ii) be able to extract the individual parts of the date and display them in UK formatHave no idea what is 'UK format'. But you can use the DATE_FORMAT MySQL function to do the same DATE_FORMAT(
yourdatefield, '%m.%d.%Y') as date_formatted [...]
Also, http://php.net/date