Convert timestamp value into date value in oracle table query

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