Oracle
ceil() 向上取整
1.查询每天的数据,并以天分组
SELECT COUNT(*),ceil(float_time) FROM TABLE_NAME GROUP BY ceil(float_time);
2.查询每小时的数据,并以小时分组
SELECT COUNT(*),ceil((ceil(float_time)-float_time)*24) FROM TABLE_NAME GROUP BY ceil((ceil(float_time)-float_time)*24);
3.排序,以1为例子
SELECT COUNT(*),ceil(float_time) FROM TABLE_NAME GROUP BY ceil(float_time)
ORDER BY ceil(float_time);
4.转timestamp型
to_timestamp('2006-01-01 12:10:10.1','yyyy-mm-dd hh24:mi:ss.ff')
5.关于ORACLE
DATE型-DATE型为数字
TIMESTAMP-TIMESTAMP依旧是TIMESTAMP型
判断用DATE-TO_DATE(TIMESTAMP,'YYYY-MM-DD HH24:MI:SS')
或者DATE-(TIMESTAMP+0)