I don't see this in the TO_DATE documentation, and because it's January I
can't see how to test this to confirm.

select to_date('2009','YYYY') from dual;
=> shows 01-JAN-2009

The day is defaulting to 1, but what of the month?

- is the unspecified month defaulting to 1 (i.e. January)

- or is the unspecified month defaulting to the current month (which just
happens to be January because of when I ran the test).


Thanks for any feedback.

Malcolm Dew-Jones schrieb:
From
http://download.oracle.com/docs/cd/B....htm#sthref795

DATE Datatype

You use the DATE datatype to store fixed-length datetimes, which include
the time of day in seconds since midnight. The date portion defaults to
the first day of the current month; the time portion defaults to
midnight. The date function SYSDATE returns the current date and time.

So, if you query the same in february, you'll get 01-FEB-2009

Best regards

Maxim

On Sun, 11 Jan 2009, Maxim Demenko wrote:

Thanks,

I didn't think to look at the _data type_ documentation, I was looking at
the conversion functions (TO_DATE from char).

"Malcolm Dew-Jones" <yf110 (AT) vtn1 (DOT) victoria.tc.ca> a écrit dans le message de news: 4967e206$1 (AT) news (DOT) victoria.tc.ca...
SQL> select to_date('2009','YYYY') from dual;
TO_DATE('2009','YYY
-------------------
01/03/2009 00:00:00

1 row selected.

Regards
Michel

On 3 mar, 20:08, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
Hi all.

The default year, month and day is a little convoluted...

I wrote about it a while ago. You may take a look here:

http://carlosal.wordpress.com/2007/0...o-con-to_date/

It's written in spanish, but SQL is SQL is SQL ;-)

HTH.

Cheers.

Carlos.