Problems with time format with milliseconds

[Tinho]

Good evening,

I created a log recording process and I would like to store the inclusion date in the full format, example: DD/MM/RR HH24:MI:SS.FF6 or DD/MM/RR HH24:MI:SSXFF TZR, but when running the query below:

SELECT TO_TIMESTAMP_TZ(TO_CHAR(SYSTIMESTAMP, 'DD/MM/RR HH24:MI:SSXFF TZR'), 'DD/MM/RR HH24:MI:SSXFF TZR') AS converted_timestamp
      ,TO_TIMESTAMP_TZ(TO_CHAR(SYSTIMESTAMP, 'DD/MM/RR HH24:MI:SS.FF6'), 'DD/MM/RR HH24:MI:SS.FF6') AS timestamp_converted
FROM dual;

It is displayed as follows:

09/30/24 19:4 09/30/24 19:4

I already changed the settings in Preferences -> User Interface -> NLS Option, restarted PL/SQL Developer, but the problem continued. Searching the internet for a possible solution, I found an option that would be to change the params.ini file and include the following lines at the end of the file:

plsqldev.exe env:nls_time_format=hh24:mi:ssxff
plsqldev.exe env:nls_timestamp_format=dd/mm/rr hh24:mi:ssxff
plsqldev.exe env:nls_timestamp_tz_format=dd/mm/rr hh24:mi:ssxff tzr
plsqldev.exe env:nls_time_tz_format=hh24:mi:ssxff tzr

Again, I restarted PL/SQL Developer, but nothing changed.

I tested the execution of the above query in SQL Plus and the date and time were displayed in the expected format. Therefore, I believe it is a display problem related to the All Round Automations IDE itself.

I have exhausted the options for resolving this inconvenience. So I would like to know if you could help me?

Thank you in advance.

Available.

Yours sincerely

 

[Marco Kalter]

Can you let me know the results of the following query?

select * from nls_session_parameters
where parameter like 'NLS_TIMESTAMP%'

 

[Tinho]

Hello,

Thanks for the feedback, follow:

-- PARAMETER VALUE
-- NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
-- NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR

Regards

 

[Marco Kalter]

Can you change the “Time‿ format setting in the preferences to “Windows format‿ and try the original query again?