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' ) Quote Link to comment Share on other sites More sharing options...
fenway Posted June 2, 2008 Share Posted June 2, 2008 Let's see the solution....? 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.