date and time

[Baila_me]

The date and time in my PL/SQL developer looks very strange. For example the gen-date for a custum order is 21.02.19 16:45:02,266859000

What is the number after the comma and how can i diaable the number?

 

[patch]

The number behind the comma are the milliseconds. You can hide this by removing the FF from the datemask.

 

[Baila_me]

Is it possible to Disable the milliseconds default in the PL/SQL developer.

 

[Marco Kalter]

The timestamp formats are defined by the NLS_TIMESTAMP_FORMAT setting.

The format can be set in the Oracle registry, in which case it will apply to all Oracle Client applications, or in the Params.ini file in the PL/SQL Developer installation directory. You can add a line like this:

ENV:NLS_TIMESTAMP_FORMAT=DD-MM-YYYY HH24:MI:SS

 

[Baila_me]

it works! Thanks.

 

[S. Studeny]

Yes, but you are missing IMPORTANT point ..

seehttps://forums.allroundautomations....bb=showflat&Main=15420&Number=58813#Post58813