方法一
SELECT
createtime
FROM
um_user
WHERE
createtime BETWEEN to_date( '2018-01-01', 'yyyy-mm-dd' )
AND to_date( '2018-12-31', 'yyyy-mm-dd' )
ORDER BY
createtime DESC
方法二
SELECT
createtime
FROM
um_user
WHERE
createtime BETWEEN date '2018-01-01'
AND date '2018-12-31'
ORDER BY
createtime DESC