piyush23424 Posted February 3, 2010 Share Posted February 3, 2010 Hi, i am having a column with datatype date in the 'session' table, there are more than 200 records in this table. what will be the query to find the records having date lower than given date(i am using a drop down box to select date). let say if user enters 01-01-2010 date it should show all the records with date range from 01-01-2010 to 03-01-2010(today) Thanks Quote Link to comment https://forums.phpfreaks.com/topic/190738-date-comparisions/ Share on other sites More sharing options...
scept1c Posted February 3, 2010 Share Posted February 3, 2010 so the argument should be compared with both registration_date and today_date as far as i understood? Quote Link to comment https://forums.phpfreaks.com/topic/190738-date-comparisions/#findComment-1006072 Share on other sites More sharing options...
piyush23424 Posted February 3, 2010 Author Share Posted February 3, 2010 so the argument should be compared with both registration_date and today_date as far as i understood? Thanks for replying:: Yes, the query should search the records having dates between 'selected' date and today's date Quote Link to comment https://forums.phpfreaks.com/topic/190738-date-comparisions/#findComment-1006236 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.