Re: Oracle Dates

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 5 Jan 2010 17:48:40 -0700
Message-ID: <4b43ebf8$1_at_news.victoria.tc.ca>



The Magnet (art_at_unsu.com) wrote:

: Is there a way for me to figure out how many days in 3 months? For

I can't test this, but my first thought is to try something like this example for counting the days in Jan Feb and March of this year.

	number count_days_in_3_months :=
	to_date('1-APR-2010','DD-MON-YYYY')
	- to_date('1-JAN-2010','DD-MON-YYYY') 
Received on Tue Jan 05 2010 - 18:48:40 CST

Original text of this message