pgsql数据库常用操作

//月份范围查询数据
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'