Archives of the TeradataForum

Message Posted: Fri, 28 Mar 2008 @ 21:56:33 GMT

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

Hi Kishore, you can use the sys_calendar.calendar view.

     Select dob from emp
     Union
     select calendar_date from sys_calendar.calendar
     where calendar_date = date - 30

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