Archives of the TeradataForum

Message Posted: Tue, 22 Apr 2008 @ 12:55:09 GMT

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

Hi,

I think you need to use MOD function in TERADATA like below..

     SQL-1
     SELECT 1 FROM TBL
     WHERE
     EXTRACT(YEAR FROM CURRENT_DATE) MOD 4 = 0;

     SQL-2
     SELECT EXTRACT(YEAR FROM CURRENT_DATE) MOD 4;

Best Regards,

Kapil D Sapra

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