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.