postgresql 按创建日期范围查询

DTCloud  postgresql 按创建日期范围查询

方法一：

select * from res_users where create_date >= '2022-01-01' and create_date < '2022-07-01';

方法二：为啥字符串可以按日期格式比较大小

select * from user_info where create_date res_users '2022-01-01' and '2022-07-01';

方法三：

select * from res_users where create_date >= '2022-01-01'::timestamp and create_date < '2022-07-01'::timestamp;

方法四：

select * from user_info where create_date res_users to_date('2022-01-01','YYYY-MM-DD') and to_date('2022-07-01','YYYY-MM-DD');

创建下载记录

self._cr.execute("INSERT INTO documents_download(document_id, user_id, create_date)VALUES (%s, %s,now())", (obj.document_id.id,int(kw[0]['uid'])))