• method 1

select * from user_info where create_date >= '2019-05-01' and create_date < '2019-08-15';

 

  • method 2

select * from user_info where create_date between '2019-05-01' and '2019-08-15';

 

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

  • method 3

select * from user_info where create_date >= '2019-05-01'::timestamp and create_date < '2019-08-15'::timestamp;

 

  • method 4

select * from user_info where create_date between to_date('2019-05-01','YYYY-MM-DD') and to_date('2019-08-15','YYYY-MM-DD');

 

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄