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_add(LAST_DAY(DATE_SUB(CURRENT_DATE(),INTERVAL 1 YEAR)),interval 1 DAY),interval -1 MONTH);

      Year-Month to last year-month data calculation

SELECT  IF(is_qualified = 0, DATE_FORMAT(en_date, '%m'), DATE_FORMAT(qualified_date, '%m') ) AS enqMonth,  IF(is_qualified = 0, DATE_FORMAT(en_date, '%M'), DATE_FORMAT(qualified_date, '%M')) AS enqStrMonth, IF(is_qualified = 0, DATE_FORMAT(en_date, '%y'), DATE_FORMAT(qualified_date, '%y')) AS enqYear, SUM(IF(is_qualified = 0, 1, 0)) AS enquiryCnt, SUM(IF(is_qualified = 1, IF(is_deleted = 0, 1, 0), 0)) AS bookingCnt FROM `enquiry` WHERE  `en_date` >= date_add(date_add(LAST_DAY(DATE_SUB(CURRENT_DATE(),INTERVAL 1 YEAR)),interval 1 DAY),interval -1 MONTH) AND `is_deleted` = 0 AND `en_date` <> 'null'  GROUP BY `enqYear`,`enqMonth` ORDER BY `enqYear`, `enqMonth`;

       O/P:

       

       Get hr/min from now() in sql 

       Select DATE_FORMAT(now(), "%Y-%m-%d %H:%i");