PostgreSQL Query by date range

There are several ways to query by date range, and the Date field type is typically:

without timezone

Method One:

select * from user_info where create_date >= ‘2015-07-01‘ and create_date < ‘2015-08-15‘;

Method Two:

select * from user_info where create_date between ‘2015-07-01‘ and ‘2015-08-15‘;

Method Three:

select * from user_info where create_date >= ‘2015-07-01‘::timestamp  and create_date < ‘2015-08-15‘::timestamp;

Method Four:

select * from user_info where create_date between to_date(‘2015-07-01‘,‘YYYY-MM-DD‘) and to_date(‘2015-08-15‘,‘YYYY-MM-DD‘);

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

PostgreSQL Query by date range