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

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



      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?



      I configured my SQL Developer Settings by adding the option

      AddVMOption -Duser.language=en

      in the file "sqldeveloper.conf".