Archives of the TeradataForum

Message Posted: Wed, 08 Jun 2005 @ 12:36:33 GMT

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

Hi,

Assume your period as June, 2005 i.e. '200506'. Try out this -

     SELECT ADD_MONTHS(CAST (('200506' || '01') AS DATE FORMAT 'YYYYMMDD'), -26);

Thanks.

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