TRUNC函数为指定元素而截去的日期值
TRUNC(date[,fmt])
select trunc(to_date('1970-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss')+time/60/60/24) time from multippp_info order by time desc //截取到日
select trunc(to_date('1970-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss')+time/60/60/24,'dd') time from multippp_info order by time desc //截取到日
select trunc(to_date('1970-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss')+time/60/60/24,'day') time from multippp_info order by time desc //截取到本周的第一天,即上周日