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!

Date format coming in sql developer but not in sqlplus

Uday_NFeb 10 2021

Hi All,
When i execute the following command it works fine in sql developer but not in sql plus
SELECT TO_CHAR(to_timestamp(SYSDATE),'YYYY-MM-DD-HH24.MI.SS.FF6')FROM DUAL;

In sql plus it throws an error ' not a valid month' . Is there any setting I am missing ? I need the output based on the format mentioned above. Please kind your advice.

Regards,
Uday

This post has been answered by Frank Kulash on Feb 10 2021

Jump to Answer

Added on Feb 10 2021

#sqlplus

7 comments

2,650 views

2 mentions