Regresar
-
Título
am/pm indicator wrong after setting nls_date_format -
Descripción
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.
Debe iniciar sesión
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.