5 Replies Latest reply on Nov 25, 2019 5:36 PM by Glen Conway

    SQL Editor Code template: Date format of Id #date# #time#

    @c*689064*

      Hi,

      I often use a SQL Editor Code template with IDs  #date# #time# to generate the current Date-Time as an comment in my scripts. But I'd like to have this Date-Time formatted to 'rrrr-mm-dd hh24:mi:ss', but it's for example generated as '11/22/19 4:59:03 PM'. How can I change this format?

       

      Info:

      I configured my SQL Developer Settings by adding the option

      AddVMOption -Duser.language=en

      in the file "sqldeveloper.conf".

       

      Tankx,

      Chris