Archives of the TeradataForum

Message Posted: Wed, 29 Nov 2006 @ 16:49:50 GMT

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

There are probably loads of easier ways to do it (as no doubt Victor or Dieter will demonstrate) but...

     sel
     trim(extract(year from
     ('2006-01-09'(date,format'yyyy-mm-dd'))))||'-'||((((('2006-01-09'(date,f
     ormat'yyyy-mm-dd'))-('2006-01-01' (date,format'yyyy-mm-dd')))/7)+1)(format'99'))

simple eh :-)

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