Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

sqlcl : sysdate output problem

User_EYH5LMay 2 2016 — edited May 9 2016

Hello,

the new version of sqlcl is great, but I have a problem with SYSDATE function.

The following sql command :

SELECT SYSDATE FROM DUAL;

returns :

     * sqlplus output : 05/02/2016 12:05:02

     * sqlcl (previous version) output : 05/02/2016 12:05:02

    * sqlcl (new version) output : 05/02/2016    

    

sqlplus and old sqlcl behavior is the same and it fine.

but new sql version display a truncated sysdate. could you fix this, in order to align the behavior with sqlplus ?

thank you.

Comments
Post Details
Added on May 2 2016
2 comments
684 views