?
Solved

convert unix time stamp to oracle date format

Posted on 2006-06-28
5
Medium Priority
?
16,109 Views
Last Modified: 2013-12-12
is it possible convert a unix time stamp 1151530818 into oracle date format  jan-22-1987  
0
Comment
Question by:sweetysmile
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:sathyagiri
ID: 17005688
Try this

select to_date('01-JAN-1970 00:00:00, 'DD-MON-YYYY HH:MI:SS') + NUMTODSINTERVAL(1151530818,'SECOND') from dual;
0
 

Author Comment

by:sweetysmile
ID: 17005743
hey its giving an error

hour must be between 1 and 12
0
 
LVL 14

Accepted Solution

by:
sathyagiri earned 1000 total points
ID: 17005760


Change it to
 

select to_date('01-JAN-1970 00:00:00, 'DD-MON-YYYY HH24:MI:SS') + NUMTODSINTERVAL(1151530818,'SECOND') from dual;
 
0
 

Author Comment

by:sweetysmile
ID: 17005779
hey thanks a lot it worked
0
 
LVL 14

Expert Comment

by:sathyagiri
ID: 17005790
Missed a quote again sorry
select to_date('01-JAN-1970 00:00:00', 'DD-MON-YYYY HH24:MI:SS') + NUMTODSINTERVAL(1151530818,'SECOND') from dual;
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month9 days, 2 hours left to enroll

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question