Archives of the TeradataForum

Message Posted: Tue, 22 Apr 2008 @ 12:34:18 GMT

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

Hi ,

Can I use MOD operator with in the stored procedure?

Its working fine individually but with in the procedure its asking for something between ( and MOD .

Could you please help on this I don't know why its showing like that.

     CAST(MOD(EXTRACT(YEAR FROM CURRENT_DATE),4)  AS CHAR) = 0

Thanks in Advance....

srinivas

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