Timestamp without timezone
方法一:
select * from user_info where create_date >= '2015-07-01' and create_date < '2015-08-15';
方法二:为啥字符串可以按日期格式比较大小
select * from user_info where create_date between '2015-07-01' and '2015-08-15';
方法三:
select * from user_info where create_date >= '2015-07-01'::timestamp and create_date < '2015-08-15'::timestamp;
方法四:
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');