Archives of the TeradataForum

Message Posted: Mon, 06 Jun 2005 @ 11:34:05 GMT

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

This worked for me:

     select add_months(cast (yourdate||'01' as date format 'yyyymmdd'),-36)
          from your_table

Merv

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