比较两个不同表中的当前日期并在Mysql中获取数据

Question

I have two tables 'Customer_details' and 'Application_Status' both tables have the date, a where-in customer_details table has

Signup Date[Format: DD/MM/YYYY (04/12/2018 10:30:00 AM)]

and Application_Status has

Application Date[Format: YYYY-MM-DD (2018-12-04 04:00:00 PM)].

I want to compare both dates with Present Date and fetch both table data.

Answer 1

Please try this query.

SELECT *
      FROM Customer_details AS cdel
      INNER JOIN Application_Status AS asts
      ON cdel.c_id  = asts.c_id
      WHERE cdel.date = CURDATE() AND asts.date = CURDATE();

Or you can use NOW() function as:

SELECT *
          FROM Customer_details AS cdel
          INNER JOIN Application_Status AS asts
          ON cdel.c_id  = asts.c_id
          WHERE cdel.date = NOW() AND asts.date = NOW();

Note:

SELECT NOW();     -- You will get 2010-12-09 17:10:18
SELECT CURDATE(); -- You will get 2010-12-09

reference