--将绝对秒数为1429056000转为DATE
SELECT TO_DATE('1970-1-1','YYYY-MM-DD')+(1429056000/(3600*24)) FROM DUAL;
--将2015-4-15转为绝对秒数
SELECT (TO_DATE('2015-4-15','YYYY-MM-DD') - TO_DATE('1970-1-1','YYYY-MM-DD'))*24*3600 FROM DUAL;
--将绝对秒数为1429056000转为DATE
SELECT TO_DATE('1970-1-1','YYYY-MM-DD')+(1429056000/(3600*24)) FROM DUAL;
--将2015-4-15转为绝对秒数
SELECT (TO_DATE('2015-4-15','YYYY-MM-DD') - TO_DATE('1970-1-1','YYYY-MM-DD'))*24*3600 FROM DUAL;