Archives of the TeradataForum

Message Posted: Wed, 25 Jan 2012 @ 20:14:37 GMT

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

You could use the system calendar.

     select calendar_date , calendar_date(format'EEEE')(char(9))
     from sys_calendar . calendar
     where   year_of_calendar = 2012
     and day_of_week = 7
     and weekday_of_month = 3
     ;

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