SQL-时间篇

当前时间

//时分秒
select(now()::TIMESTAMP(0))

今天：今天0点到当前的时间

//时分秒  2023-07-11 17:50:18
time between (select (current_date-interval '0day')) and (select (current_date+interval '1day'))
 
//13位时间戳
time between (select floor(extract(epoch from current_date))*1000-8*60*60*1000::bigint) and (select floor(extract(epoch from now()))*1000)

1天：昨天当前时间到今天当前时间

//时分秒
方法1：time between (select to_char(now()-interval'1day','yyyy-MM-dd HH24:MI:SS')::timestamp without time zone) and (select to_char(now(),'yyyy-MM-dd HH24:MI:SS')::timestamp without time zone)
方法2：time between (select (now()::timestamp(0)-interval '1day')) and (select now()::timestamp(0))

7天

// 时分秒
//今天的数据加前六天（0时-24时）的数据 
time between (select (current_date-interval '6day')) and (select (current_date+interval '1day'))
//6天前当前时间的数据到今天当前时间的数据
time between (select (now()::timestamp(0)-interval '6day')) and (select now()::timestamp(0))

30天

//时分秒
//今天的数据加前29天（0时-24时）的数据
time between (select (current_date-interval '29day')) and (select (current_date+interval '1day'))
//30天前当前时间的数据到今天当前时间的数据
time between (select (now()::timestamp(0)-interval '29day')) and (select now()::timestamp(0))