Re: Dates and Mysql
| From: | Kevin Waterson | Date: | Thu, 11 Dec 2008 07:53:09 +0000 |
| Subject: | Re: Dates and Mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-284464@lists.php.net to get a copy of this message | ||
This one time, at band camp, VamVan <vamseevan@gmail.com> wrote:
> I was wondering how is it possible for me to query the table to retrieve all
> the records that are one week less than the time stamp?
SELECT DATE_SUB(date_time_column, INTERVAL 1 WEEK) FROM your_table;
http://www.phpro.org/tutorials/Introduction-to-PHP-and-MySQL.html#45
Kevin