Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: seconds from midnight into a date field?
Look harder. From the FM (SQL Reference - date format models):
SSSSS Seconds past midnight (0-86399).
Quoting ryan.gaffuri_at_comcast.net:
> 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
> 0001
> 0050
> 1054
> I can't find a to_date function to translate that. do any exist?
>
-- Regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Jul 12 2004 - 08:39:03 CDT