Postgresql/Greenplum:
字段支持timestamp类型
select *
from 表名 WHERE CURRENT_TIMESTAMP-"tempstamp类型字段名" <= interval '60 DAY/HOUR'
mysql:
查询day,week,month:
SELECT * FROM 表名 WHERE TIME(tempstamp类型字段名)>= DATE_SUB(NOW(),INTERVAL 1 HOUR/DAY) /*查询1小时/1天也可以是WEEK和MONTH*/
oracle:
查询day,week,month:
select * from "表名"
where trunc("tempstamp类型字段名")>trunc(sysdate-30)
查询前一下小时:
select * from "表名"
where "字段名">sysdate-1/24
sqlserver:
SELECT * FROM 表名 WHERE datediff(hh/dd/month/week,字段名,GETDATE())<=1
HIVE:
查询day,week,month:
SELECT * FROM 表名 WHERE datediff(current_date,字段名)<=80
查询小时级别:
SELECT * FROM 表名 WHERE DATE_FORMAT(from_unixtime(unix_timestamp()-3600),'yyyy-MM-dd HH:mm:ss')<=字段名
指定日期的分段:
SELECT * FROM 表名 WHERE DATE_FORMAT(from_unixtime(unix_timestamp('2021-06-10 06:53:24')-3600),'yyyy-MM-dd HH:mm:ss')<=字段名
达梦数据库:
查询day,week,month:
SELECT * FROM "数据库名"."表名" where DAYS_BETWEEN(NOW(),BD_TIMESTAMP)<1
查询前一下小时:
select*FROM "aaasss"."TABLE_1" where DATEDIFF(MINUTE/DD/HH/MM,BD_TIMESTAMP,NOW())<=60
DB2:
查询day,week,month:
SELECT * FROM 表名 WHERE CURRENT timestamp-字段名>=1
查询前一下小时:
SELECT * FROM 表名 WHERE DATEDIFF(MINUTE,字段名,CURRENT timestamp)<=60