RE: sybase date field to Oracle - sqlldr

From: John Hallas <john.hallas_at_bjss.co.uk>
Date: Tue, 18 Sep 2007 12:03:00 +0100
Message-ID: <E02CB9B2777CF8459C86C49B48C48EC6024B5C78@exchange.bjss.co.uk>

Thank you for your help and the example page you sent me.

Works into both date and timestamp formatted columns  

John  

---

From: anysql [mailto:anysql_at_gmail.com]
Sent: 18 September 2007 11:35
To: John Hallas; oracle-l_at_freelists.org
Subject: Re: sybase date field to Oracle - sqlldr  

SQL> select to_timestamp('Sep 17 2007 7:00:00:020AM', 'Mon dd YYYY hh:mi:ss:ffAM') from dual;  

TO_TIMESTAMP('SEP1720077:00:00:020AM','MONDDYYYYHH:MI:SS:FFAM')

---

17-SEP-07 07.00.00.020000000 AM     From： John Hallas ����Sent： 2007-09-18 18:17:31 ����To： oracle-l_at_freelists.org ����CC： ����Subject： sybase date field to Oracle - sqlldr ����Oracle 10.2.0.3 - Solaris ����I am trying to load dump files from a Sybase database and I am struggling over the date columns. The flat files have a date format of “Sep 17 2007 7:00:00:020AM”����

BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW. Registered in England with company number 2777575. http://www.bjss.co.uk

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 18 2007 - 06:03:00 CDT