mdemetri2 Posted August 21, 2013 Share Posted August 21, 2013 Hi I'm sure this should be straight forward but I keep getting errors, so I have a query: Select * from table where STR_TO_DATE(updatedate, '%d/%m/%Y : %H:%i') >now()-1; I essentially want any records that have been updated sometime today to be brought back and I know now()-1 would be timenow minus 1 day if the syntax above is correct. I know there are some records as I have updated some for testing purposes. I think the issue is where I am needed to convert the string held date....any ideas? Thank you so much in advance. Quote Link to comment https://forums.phpfreaks.com/topic/281425-help-with-str_to_date-and-now/ Share on other sites More sharing options...
Solution Barand Posted August 21, 2013 Solution Share Posted August 21, 2013 syntax is NOW() - INTERVAL 1 DAY Quote Link to comment https://forums.phpfreaks.com/topic/281425-help-with-str_to_date-and-now/#findComment-1446091 Share on other sites More sharing options...
mdemetri2 Posted August 21, 2013 Author Share Posted August 21, 2013 (edited) spot on! you are a star, very much appreciated Barand! Edited August 21, 2013 by mdemetri2 Quote Link to comment https://forums.phpfreaks.com/topic/281425-help-with-str_to_date-and-now/#findComment-1446092 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.