Q: Default month in TO_DATE

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 9 Jan 2009 15:47:18 -0700
Message-ID: <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. Received on Fri Jan 09 2009 - 16:47:18 CST

Original text of this message