Sql useful quiries
Today's enquiry SELECT * FROM `enquiry` WHERE `en_date` >= date('Y-m-d'). ' 00:00:00'; Tomorrow's enquiry SELECT * FROM `enquiry` WHERE `en_servicedate` = date('Y-m-d', strtotime(date("Y-m-d") . " +1 day")). ' 00:00:00'; Yesterday's enquiry SELECT * FROM `enquiry` WHERE `en_date` >= date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'))). ' 00:00:00' AND `en_date` <= date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'))). ' 23:59:59'; This Month's booking SELECT * FROM `enquiry` WHERE `qualified_date` >= date('Y-m-01') . ' 00:00:00' AND `qualified_date` <= date('Y-m-d') . ' 23:59:59'; Current date to previous year month (ex- 21-4-2018 to 1-8-2017) SELECT * from enquiry where en_date >= date_add(date_ad...