postgresql时间范围查询

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