在oracle数据库中怎么对一个date类型的字段使用between...and...子句

 方法一​​​​​​​

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

 结果展示

版权声明：本文为qq_29001173原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。