SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use quarter format in "to_date()" function?

268009May 1 2002

Hi,

I'm trying to use to_date() function with quarter format. How do I specify the format?

For example to convert '2002 quarter 1' using the to_date function.

I tried to_date('20021', 'YYYYQ'), and I got ORA-01820 cannot appear in date input format.

Please help, thank you!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2002

Added on May 1 2002

2 comments

4,677 views