We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
how do I resolve error ORA-01861 during query execution
Posted on 2011-09-26
When i execute the following query:
elect pdf_name, site, to_char(publication_date, 'YYYY-MM-DD') as publication_date, modified_date, db_inserted,db_updated from bib_holdings where publication_date <= '1900-01-01';
I get the ORA-01861 error
It is not apparant to me how I am formatting my literal string the wrong way. can someone help me with this?
elect pdf_name, site, to_char(publication_date, 'YYYY-MM-DD') as publication_date, modified_date, db_inserted,db_updated from bib_holdings where publication_date <= '1900-01-01';
I get the ORA-01861 error
It is not apparant to me how I am formatting my literal string the wrong way. can someone help me with this?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Active today
Change:
publication_date <= '1900-01-01'
to:
publication_date <= to_date('1900-01-01','YYYY
publication_date <= '1900-01-01'
to:
publication_date <= to_date('1900-01-01','YYYY
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Checking for column width | 8 | 49 | |
| grant privilege to execute a procedure for user in another database | 20 | 51 | |
| Errror when importing data from Oracle to SQL | 6 | 67 | |
| Oracle cluster . | 1 | 25 |
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the dā¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
In a previous video, we went over how to export a DynamoDB table into Amazon S3. In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses
Course of the Month4 days, 22 hours left to enroll
738 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.