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. Link to comment https://forums.phpfreaks.com/topic/281425-help-with-str_to_date-and-now/ Share on other sites More sharing options...
Barand Posted August 21, 2013 Share Posted August 21, 2013 syntax is NOW() - INTERVAL 1 DAY 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 spot on! you are a star, very much appreciated Barand! 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
Archived
This topic is now archived and is closed to further replies.