Re: [PHP] Dates and Mysql
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Dates and Mysql
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? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Dates and Mysql
This one time, at band camp, VamVan <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php