Question about date.

SQL> select count(*) from VIEW1 where D_DATE = TO_DATE('20010319',
'YYYYMMDD');
  COUNT(*)

         1

SQL> select count(*) from VIEW1 where D_DATE = TO_DATE('200103',
'YYYYMM');
  COUNT(*)

         0

In the view VIEW1, there is one single record where the D_DATE is in the month March 2003.

My question is why don't the two queries produce the same result?

Thanks,
--GS Received on Mon Oct 25 2004 - 13:25:15 CDT