Re: Dates and Mysql
| From: | Micah Gersten | Date: | Wed, 10 Dec 2008 23:29:00 +0000 |
| Subject: | Re: Dates and Mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-284444@lists.php.net to get a copy of this message | ||
VamVan wrote:
> Hello Gang,
>
> I have a Mysql table which has timestamp for the date the record was
> created.
>
> 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?
>
> Thanks,
> V
>
>
I'm assuming you meant get records one week less than the current system
timestamp.
date('Y-m-d G:i:s', strtotime('1 week ago'));
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com