SQL*Loader help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL*Loader help

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Location
    NYC
    Posts
    9

    SQL*Loader help

    Hi,
    Hai I am very much new to Oracle. I am trying to load data into a table using SQL*Loader and i getting error while it is using the data format.
    the format used in data file is "Sep 6 2001 12:00:00:000AM"
    and when i used to_date( :accountDate, 'YYYY-MM-DD HH:MI:SS AM or PM') function it throws me an exception like
    "ORA-01821: date format not recognized". so anybody can help me to insert data with out changing the data file, whould be really helpfull
    thanks
    vijay

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: SQL*Loader help

    Originally posted by vijay321
    ... the format used in data file is "Sep 6 2001 12:00:00:000AM"
    and when i used to_date( :accountDate, 'YYYY-MM-DD HH:MI:SS AM or PM') ...
    Change that to:
    Code:
    to_date( :accountDate, 'Mon DD YYYY hh:mi:ss":000"AM')
    and you'll be fine.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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