Archives of the TeradataForum

Message Posted: Sun, 20 Dec 2009 @ 22:39:57 GMT

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

You might try

     Select *
     From sys_calendar.calendar
     Where calendar_date = current_date.

The week_of_year column should give you what you want.

Teradata Corporation
Glenn McCall

Canberra Australia

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