|
-
We can get 22.37 hours from the 80538/60/60. What we need is to to_char the julian date to get Nov16th at 12:00am, then add 22.37 to it. I'm trying but when it adds 22 it's adding days instead of minutes. Let me play a little longer.
Edit:
Run this
select to_char(to_date('2451865', 'J') + 80538/60/60/24, 'DD-MM-YYYY HH24:MI:SS') from dual
Just change my hard coded numbers to your startup time value's and it should work.
[Edited by pwoneill on 11-17-2000 at 12:15 PM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|