dateDiff.sql

    1. SELECT
    2. id AS '用户id',
    3. create_time AS '注册时间',
    4. DATEDIFF(NOW(), create_time) AS '注册天数'
    5. FROM
    6. jmf_sys_user
    7. WHERE
    8. id = 2014353867018240