[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

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

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?

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;