RE: SQLLoader and RR date format

The ORACLE magazine issue Jan/Feb 1999 topic"Get Compliant or Take Cover" = does an excellent explanation about Oracle's battle with the century = change and the methods used to handle the changes. Well worth the reading for info about dates. Ron Rogers
DBA
Atl.GA

>>> Deepender_Gupta_at_escorts.co.in 07/21/00 03:24AM >>>

can somebody tell the difference between RRRR and YYYY format ???

      03:02 AM

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>@SMTP_at_AMG1=

cc:

If you're using the year format RR, you can't expect YYYY to work. As far as I know, you must use RRRR.

Michael Armstead

> -----Original Message-----
> From: Michael Parry [SMTP:parrymd_at_yahoo.com]=20
> Sent: Wednesday, July 19, 2000 4:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQLLoader and RR date format
>
> Hi most knowledgeable ones,
>
> I have an 8.0.5 database with the date format set to
> DD-MON-RR. I'm trying to load data through sqlloader
> with date data formatted as RRMMDD (430210 is Feb 10th
> 1943). The query results return 10-FEB-2043 using
> to_date(mydate,'DD-MON-YYYY').
>
> Is there a way in sqlloader to load this date in it's
> current format and have it show in the database as
> 1943?
>
> Am I missing something?
>
> Data to load: 430210
> Ctl code: birthday position(1:6) date 'RRMMDD'
> Table column: birthday date
>
> Thanks, Mike
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/=20
> --
> Author: Michael Parry
> INET: parrymd_at_yahoo.com=20
>
> 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: ListGuru_at_fatcity.com (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).

--
Author: Armstead, Michael A
  INET: maa25681_at_glaxowellcome.com=20

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: ListGuru_at_fatcity.com (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).






--=20
Author:=20
  INET: Deepender_Gupta_at_escorts.co.in=20

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: ListGuru_at_fatcity.com (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