Archives of the TeradataForum

Message Posted: Wed, 29 Nov 2006 @ 16:51:21 GMT

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

The easiest technigue to get week-of-year is to use the system calendar.

     sel week_of_year
     from sys_calendar.calendar
     where calendar_date=date

Normally this would be done as a join using your activity date being joined to the calendar_date column.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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