pg数据库中获取，前一个小时和获取当前时间函数用法_pg 获取时间戳小时

背影：需要写一个sql让BOMC来监控文件有没有采集生成

小时用法：select CURRENT_TIMESTAMP - INTERVAL '1 hour'

select distinct metricgroup_name from s_datafile where 
begin_time >= (select CURRENT_TIMESTAMP - INTERVAL '1 hour')
and file_path  like '%ZG-PE-CIF-PROBE_CM_D%' 

D_ACTIVEALARM
D_SIGNALH
 

天用法：select current_date;
select distinct metricgroup_name from s_datafile where 
begin_time >= (select current_date) and file_path  like '%ZG-PE-CIF-PROBE_CM_M%' 

M_SIGNAL
M_AREA
M_DEVICE
M_ROOM
M_SITE