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 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? 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 Link to comment https://forums.phpfreaks.com/topic/190738-date-comparisions/#findComment-1006236 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.