Re: Default month in TO_DATE
Date: Tue, 3 Mar 2009 20:08:43 +0100
"Malcolm Dew-Jones" <yf110_at_vtn1.victoria.tc.ca> a écrit dans le message de news: 4967e206$1_at_news.victoria.tc.ca...
|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.
SQL> select to_date('2009','YYYY') from dual; TO_DATE('2009','YYY
1 row selected.
Michel Received on Tue Mar 03 2009 - 13:08:43 CST