postgresql数据库查询几年内几月内几日内数据_pg 查询半年的数据

获取5年内的数据

 select create_time
 from xj_check as n
 where  n.create_time>=to_timestamp(substring(to_char(now(),'yyyy-MM-dd hh24:MI:ss') FROM 1 FOR 10),'yyyy-MM-dd')- interval '5 year'    order by create_time desc 
1
2
3

获取5月内数据

select create_time
 from xj_check as n
 where  n.create_time>=to_timestamp(substring(to_char(now(),'yyyy-MM-dd hh24:MI:ss') FROM 1 FOR 10),'yyyy-MM-dd')- interval '5 month' 
 order by create_time desc 
1
2
3
4

获取5日内数据

select create_time
 from xj_check as n
 where  n.create_time>=to_timestamp(substring(to_char(now(),'yyyy-MM-dd hh24:MI:ss') FROM 1 FOR 10),'yyyy-MM-dd')- interval '5 day' 
 order by create_time desc 
1
2
3
4