Yes I know. But how is the syntax with loader? Can I provide the information in the controlfile? i found a possibility to set NLS_DATE_LANGUAGE BEFORE calling the sqlloader, but how is the syntax in the controlfile in following line .... Date_field date 'Mon dd yyyy hh:mi:ss' "RTRIM(:Date_date,':000AM')", ... ? Or is setting the environment only way to solve this? Regards, Antje > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [SMTP:[EMAIL PROTECTED]] > Gesendet am: Freitag, 19. Juli 2002 11:36 > An: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Betreff: RE: SQLLOader + nls_date_language > > e.g > > SELECT TO_DATE('January 15, 1989, 11:00 A.M.', > 'Month dd, YYYY, HH:MI A.M.','NLS_DATE_LANGUAGE = American') > FROM DUAL; > > > -----Original Message----- > From: Antje.Sackwitz [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 19, 2002 2:53 PM > To: ORACLE-L > Cc: Antje.Sackwitz > Subject: SQLLOader + nls_date_language > > > Hi, > I want to precice my question on SQLLoader and date format: > I want to give my date field a special nls_date_language. > Can Anyone help with the syntax? > Regards, > Antje Sackwitz > > ____________________________ > Antje Sackwitz > ppi Media GmbH > Deliusstraße 10 > D-24114 Kiel > phone +49 (0) 43 1-53 53-2 16 > fax +49 (0) 43 1-53 53-2 22 > email mailto:[EMAIL PROTECTED] > web www.ppi.de > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > << Datei: BDY.RTF >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).