tibberous Posted January 25, 2008 Share Posted January 25, 2008 I am trying to select on the records for today. I have a date/time stored in the database, and am using mydata=curdate() in the where clause, but it isn't working, I think because curdate() is the current date, but my value is the current date + the current time. Does anyone know how to do this? Quote Link to comment https://forums.phpfreaks.com/topic/87749-sql-to-only-select-records-for-today/ Share on other sites More sharing options...
tibberous Posted January 25, 2008 Author Share Posted January 25, 2008 I figured it out Anyone know how to do the last 7 days? Quote Link to comment https://forums.phpfreaks.com/topic/87749-sql-to-only-select-records-for-today/#findComment-448830 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.