DATEDIFF使用

CREATE TABLE `datediff_test` (
  `dt` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-04-30 07:27:39');
INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-05-17 22:52:21');
INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-05-18 01:19:10');
INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-05-22 14:17:16');
INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-05-26 03:26:56');
INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-06-10 04:44:38');
INSERT INTO `test`.`datediff_test`(`dt`) VALUES ('2017-06-13 13:55:53');

查询语句

SELECT 
    dt, 
    DATEDIFF(NOW(), dt)
FROM
    datediff_test;

    const OVERDUE_DAY = "(
    CASE
      WHEN DATEDIFF(
        (
          CASE
            WHEN real_repayment IS NULL 
            THEN FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), '%Y-%m-%d') 
            ELSE FROM_UNIXTIME(real_repayment, '%Y-%m-%d') 
          END
        ), FROM_UNIXTIME(repayment_t, '%Y-%m-%d')
      ) > 0 
      THEN DATEDIFF(
        (
          CASE
            WHEN real_repayment IS NULL 
            THEN FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), '%Y-%m-%d') 
            ELSE FROM_UNIXTIME(real_repayment, '%Y-%m-%d') 
          END
        ), FROM_UNIXTIME(repayment_t, '%Y-%m-%d')
      ) 
      ELSE 0 
    END
  ) AS overdue_day";