postgresql时间范围查询

2022-06-17 本文已影响0人姜治宇

select count(*) from "user" where "createTime"::date > date '2020-01-01' and "createTime"::date < date '2022-09-09';