Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 16:42:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Just my 2 cents. Since not getting the actual last day of the month is problematic either using ADD_Months (6/30/2004, -1) which goes to 5/30, not 5/31 or '2004-03-31' - Interval '1' which returns an error, we have come up with two solutions:

1) Go to the first day of the month following the month you want the last day for and subtract 1. ADD_Months((date '2004-05-24' - Extract(day from '2004-05-24')) + 1, -5) -1. The -5 would point to whatever month follows the desired month.

2) Change the syscalendar so the every calendar date has the beginning of the month, end of the month, and end of previous month as columns in the view.

	<Prev	Next>		<<First	<Prev	Next>	Last>>