-
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.
-
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?
-
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"
-
--------------
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
-
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')
-
ps. Tamil, you're fired as well.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|