Archives of the TeradataForum

Message Posted: Wed, 29 Nov 2006 @ 15:03:40 GMT

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

Hello,

How can we found the week of the year from a date type ?

In Oracle:

     sel to_char('2006-01-09','YYYY-IW') AS WEEK_NBR  from dual;

     WEEK_NBR
     ---------------
     2006-02

How is it done in Teradata ?

Thanks

Nazy

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