Solved

convert unix time stamp to oracle date format

Posted on 2006-06-28
5
16,071 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 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Schema creation in Oracle12c 6 45
Processing of multiple cursor 6 45
Can i Import Access Table Into Oracle Using Toad 36 167
passing parameters to sql script oracle 4 40
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

786 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