Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> select to_date('2004','YYYY') NOT Jan 1 2004
When I run the following SQL
SQL> select to_date('2004','YYYY') from dual ;
The result is 01-Mar-04. I was expecting 01-Jan-04. Is it returning March because that is the current month, or does it always return March? Does anyone else get this (I'm on Oracle 8.1.6)?
Jarson Received on Wed Mar 24 2004 - 09:56:06 CST