This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,693 Users
  • 2,269,776 Discussions
  • 7,916,823 Comments

Discussions

sqlcl : sysdate output problem

User_EYH5L
User_EYH5L Member Posts: 22 Red Ribbon
edited May 9, 2016 8:49AM in SQLcl

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.

Answers