TO_DATE - get 12:00:00 AM

[DaPi]

Uh?

With nls_date_fomat = DD-MON-YYYY HH24:MI:SS

  1* SELECT  TO_DATE( '08/16/2004 01:00:00 AM',  'MM/DD/YYYY HH:MI:SS AM' )  from dual

TO_DATE('08/16/20040
--------------------
16-AUG-2004 01:00:00

  1* SELECT  TO_DATE( '08/16/2004 12:00:00 AM',  'MM/DD/YYYY HH:MI:SS AM' )  from dual

TO_DATE('08/16/20041
--------------------
16-AUG-2004 00:00:00

SQL> alter session set nls_date_format = 'MM/DD/YYYY HH:MI:SS AM' ;

SQL> SELECT  TO_DATE( '08/16/2004 12:00:00 AM',  'MM/DD/YYYY HH:MI:SS AM' )  from dual;

TO_DATE('08/16/200412:
----------------------
08/16/2004 12:00:00 AM