select * from gce_metrics.timedata_values where metrics_id = 594004 and creatED_AT > to_timestamp('30-JUN-16 03.00.24.709000000','dd-mon-rr hh24:mi:ss.FF')
and creatED_AT < to_timestamp('30-JUN-16 03.00.24.709000000','dd-mon-rr hh24:mi:ss.FF') + INTERVAL '5' minute
select * from gce_metrics.timedata_values where metrics_id = 594004 and creatED_AT > to_timestamp('30-JUN-16 03.00.24.709000000','dd-mon-rr hh24:mi:ss.FF')
and creatED_AT < to_timestamp('30-JUN-16 03.05.24.709000000','dd-mon-rr hh24:mi:ss.FF')
两种表示在5分钟内查询的写法
and creatED_AT < to_timestamp('30-JUN-16 03.00.24.709000000','dd-mon-rr hh24:mi:ss.FF') + INTERVAL '5' minute
select * from gce_metrics.timedata_values where metrics_id = 594004 and creatED_AT > to_timestamp('30-JUN-16 03.00.24.709000000','dd-mon-rr hh24:mi:ss.FF')
and creatED_AT < to_timestamp('30-JUN-16 03.05.24.709000000','dd-mon-rr hh24:mi:ss.FF')
两种表示在5分钟内查询的写法