sqlcl : sysdate output problem

User_EYH5L

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.

thatJeffSmith-Oracle

you need to configure your NLS_DATE_FORMAT, set it in your login.sql

User_EYH5L

Thank you for your answer.

but I'was a little bit confused about this point. I will adapt my code, thank you