SQL Loader Date prior to 1950
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL Loader Date prior to 1950

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Arrow SQL Loader Date prior to 1950

    Hi,

    I am trying to load some data using SQL Loader.
    If I try to insert a date prior to 1950 (ie 1942 for example) then it's loaded as 2042 in my oracle table !

    What's the problem... ? Is there a parameter I should change ?

    Thanks.
    Fabien

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Post us ur sample data(1 row from ur datafile), control file
    & also description of ur table...
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    Hi

    try this...

    set NLS_DATE_FORMAT using 'RR' or 'YYYY'.

    HTH
    pras
    Dream as if u'll live forever..Live as if u'll die today.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width