Skip to Main Content

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!

Using TO_DATE with SYSDATE is giving error.

inDiscoverAug 28 2013 — edited Aug 28 2013

I am executing below query in Oracle 11g.

select to_date(sysdate, 'DD-MON-YY') from dual.

But this query gets failed with below error. (Note that I am using Oracle SQL Developer verion 1.2.0)

ORA - 01830 : date format picture ends before converting

But the same query executed successfully in another versions of Oracle SQL Developer (1.1.3 and 3.1.07).

I am not understanding why it is behaving differently in different versions of Oracle SQL Developer editor. Is this a strange issue????????????

Any one have any idea or work around for this. Your help is well appreciated.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2013
Added on Aug 28 2013
33 comments
19,866 views