DB

timestamp값을 date형태로 변환

잘 살아보세 2009. 4. 2. 15:16
select to_date('19700101000000', 'YYYYMMDDHH24MISS') +
(to_number('1113804718')/60/60/24)
from dual ;