Hi I have a mysql table with a datetime column and was woundering how can I query the database to return the records where the date was three days ago?
| SitePoint Sponsor |
Hi I have a mysql table with a datetime column and was woundering how can I query the database to return the records where the date was three days ago?
Use MySQL-function DATE_ADD or DATE_SUB.
Sergey Bres aka tserbis, Ukraine
... or just INTERVAL.
Sergey Bres aka tserbis, Ukraine
That works thanks
Posting Permissions
Bookmarks