今天总结了一下,关于timestamp的东西,做一下记录。
select * from tb_TIME where extract(year from sysdate) = extract(year from "time1")
SELECT TO_CHAR(1112070645000 / (1000 * 60 * 60 * 24) +
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH:MI:SS') AS tdate
FROM dual
select (sysdate-to_date('1970-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss'))* 1000 * 60 * 60*24 from dual;
select cast(systimestamp as date) from dual;