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/tutoria

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-fun

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 g

[PHP] Dates and Mysql

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