trunc(sysdate - 8/24)是什么意思

Question

RT

Answer 1

-- 例如：
select trunc(to_date('2010-03-09 07:59:59','yyyy-mm-dd hh24:mi:ss')-8/24) from dual;
select trunc(to_date('2010-03-09 08:00:00','yyyy-mm-dd hh24:mi:ss')-8/24) from dual;

Answer 2

music@SZTYORA> select trunc(to_date('2010-03-09 07:59:59','yyyy-mm-dd hh24:mi:ss')-8/24) from dual;TRUNC(TO_DATE('2010
-------------------
2010-03-08 00:00:00music@SZTYORA> select trunc(to_date('2010-03-09 08:00:00','yyyy-mm-dd hh24:mi:ss')-8/24) from dual;TRUNC(TO_DATE('2010
-------------------
2010-03-09 00:00:00