Oracle表中字段为timestamp值转化为date显示的sql语句

SELECT to_date('19700101','yyyymmdd') + (TIMESTAMP_VALUE/1000/24/60/60) AS date_time FROM TABLENAME;