Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 28048 invoked from network); 19 Sep 2007 05:40:55 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 19 Sep 2007 05:40:55 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E3DA275D7C7;
 Wed, 19 Sep 2007 06:40:55 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 02807-01; Wed, 19 Sep 2007 06:40:55 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5928375D4C6;
 Wed, 19 Sep 2007 06:40:55 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 19 Sep 2007 05:55:25 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EFBB875D580
 for <Oracle-L@FreeLists.org>; Wed, 19 Sep 2007 05:55:24 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 29366-09 for <Oracle-L@FreeLists.org>;
 Wed, 19 Sep 2007 05:55:24 -0400 (EDT)
Received: from lucy.ppimedia.de (lucy.ppimedia.de [194.180.18.131])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 35BA775D5A0
 for <Oracle-L@FreeLists.org>; Wed, 19 Sep 2007 05:55:23 -0400 (EDT)
Received: by lucy.ppimedia.de (Postfix, from userid 501)
 id A10854640DE; Wed, 19 Sep 2007 11:55:21 +0200 (CEST)
Received: from max.ppinet.de (max.ppinet.de [172.31.43.64])
 by lucy.ppimedia.de (Postfix) with ESMTP id 8A6224640DD
 for <Oracle-L@FreeLists.org>; Wed, 19 Sep 2007 11:55:21 +0200 (CEST)
Received: by max.ppinet.de with Internet Mail Service (5.5.2653.19)
 id <S8VDVVJ1>; Wed, 19 Sep 2007 11:55:21 +0200
Message-ID: <6D48B8403D926449BDE8440EC7EEC46D05425E23@max.ppinet.de>
From: Antje.Stejskal@ppimedia.de
To: Oracle-L@FreeLists.org
Subject: WG: sybase datetime
Date: Wed, 19 Sep 2007 11:55:20 +0200
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Spam-Checker-Version: SpamAssassin 3.0.0 (2004-09-13) on lucy.ppimedia.de
X-Spam-Level: 
X-Spam-Status: No, score=-2.6 required=5.0 tests=ALL_TRUSTED,NO_REAL_NAME 
 autolearn=unavailable version=3.0.0
X-archive-position: 1683
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: Antje.Stejskal@ppimedia.de
Precedence: normal
Reply-to: Antje.Stejskal@ppimedia.de
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain

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