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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.