seconds from midnight into a date field?

  • From: ryan.gaffuri@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 12 Jul 2004 12:54:35 +0000

I have a varchar field that I need to migrate to a date field. it is in the 
form 'seconds from midnight' and looks like this
I can't find a to_date function to translate that. do any exist? 

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: