simon551 Posted July 16, 2007 Share Posted July 16, 2007 Hi, I'm trying to do something like this: SELECT * FROM timesheets_main WHERE timesheets_main.tsdate BETWEEN CURDATE() AND DATE_SUB(CURDATE(),1) english translation: select all records where the date is between todays date yesterday's date. Any idea how to do that? Link to comment https://forums.phpfreaks.com/topic/60143-solved-date-parameters-curdate-problem/ Share on other sites More sharing options...
fenway Posted July 16, 2007 Share Posted July 16, 2007 Yeah, you need to specify the interval as 1 DAY, not just 1. Link to comment https://forums.phpfreaks.com/topic/60143-solved-date-parameters-curdate-problem/#findComment-299512 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.