Re: WG: sybase datetime

From: anysql <anysql_at_gmail.com>
Date: Wed, 19 Sep 2007 18:29:34 +0800
Message-ID: <200709191829276468578@gmail.com>

Hi all:

The if not all rows in the text file are ended with "000AM", still a problem.

Thanks.

Good tools make work easy and improve life quality
-- http://www.dbatools.net

Personal software, life, research and professional Oracle recovery service
-- http://www.anysql.net/en

http://www.anysql.net (Chinese)

From£º Antje.Stejskal_at_ppimedia.de
Sent£º 2007-09-19 17:56:11
To£º Oracle-L_at_FreeLists.org
CC£º
Subject£º WG: sybase datetime
Hi,
I also write it to the list as I wrote yopu personally: This is what I line used in my sqlldr config file:

Col_date "to_date(rtrim('Jan 15 1989 11:00:000AM',':000AM'),'Mon dd yyyy
hh:mi:ss','NLS_DATE_LANGUAGE = American')",

Regards,
Antje
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 19 2007 - 05:29:34 CDT