The following sql statement is run in the editor using 'run as script' (F5)
alter session set nls_date_format='MON DD YYYY HH:MI:SS PM';
select sysdate from dual;
and see the following:
SYSDATE
-----------------------
NOV 07 2008 07:52:22 P11 ---> It should display 'PM'
1 row selected.
It appears the 'M' in 'PM' is being interpreted as a month field.
The same thing happens for AM - it displays A11.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center