samona Posted June 2, 2008 Share Posted June 2, 2008 Hi all, I have a problem with the following query. If I run it, it outputs all the records including the ones from previous dates. All I want is to display the records for the current date. I don't know what I'm doing wrong. SELECT *FROM Table_1 WHERE DATE_FORMAT(Current_Date, '%Y %m %d' ) = DATE_FORMAT(CURDATE(), '%Y %m %d' ) Link to comment https://forums.phpfreaks.com/topic/108391-solved-datetime-field-date_format-problem/ Share on other sites More sharing options...
fenway Posted June 2, 2008 Share Posted June 2, 2008 Let's see the solution....? Link to comment https://forums.phpfreaks.com/topic/108391-solved-datetime-field-date_format-problem/#findComment-555996 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.