//月份范围查询数据
SELECT * FROM "EMS_CHECK_DETAIL" WHERE to_char("CREATE_TIME",'yyyy-mm') BETWEEN '2021-01' and '2021-12'
//日期范围查询数据
SELECT * FROM "EMS_CHECK_DETAIL" WHERE to_char("CREATE_TIME",'yyyy-mm-dd') BETWEEN '2021-01-01' and '2022-12-01'
//年份范围查询
SELECT * FROM "EMS_CHECK_DETAIL" WHERE to_char("CREATE_TIME",'yyyy') BETWEEN '2021' and '2022'
pgsql数据库常用操作
发布时间 2024-01-03 16:39:07作者: 刘百会