ORA-01821: date format not recognized
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01821: date format not recognized

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    ORA-01821: date format not recognized

    I am getting a weird error from my database. They were shutdown over the weekend and when they come up I get the above error. Usually when I do a query like so:

    select * from system_log where log_date >= '28apr03';

    there is no problem. But today I get the above error. Any ideas? I know the DBA upgraded a different database to 9i over the weekend but this on eis still 817.

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    more info

    The table I was querying was through a link to another database. I seems that the database links are inactive. How do I reactivate them?

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: more info

    Originally posted by lesstjm
    I seems that the database links are inactive. How do I reactivate them?
    RECREATE
    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"

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    --------------
    select * from system_log where log_date >= '28apr03';
    ----------------

    Why don't you use to_date function?

    Like:

    select * from system_log
    where log_date >= to_date('28-apr-03',''dd-mon-yy');


    Tamil

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Why don't you use to_date function?

    Like:

    select * from system_log
    where log_date >= to_date('28-apr-03',''dd-mon-yy');
    Better yet, why not learn the lessons of Y2K and specify ...

    to_date('28-apr-2003','dd-mon-yyyy')

    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    ps. Tamil, you're fired as well.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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