the date in oracle is stored in seconds (like 1246067125) and i'm unable to convert it into calender date and i also need converting calender date into seconds (like 1246067125)
i tried some thing like
select to_date('01/01/1970','DD/MM/YYYY') + trunc(creation_date/86400) from table; but i'm not sure about it

BTW - how to insert calender date into oracle, where date is stored in seconds..

Thanks in advance