Archives of the TeradataForum

Message Posted: Wed, 13 Feb 2008 @ 11:40:36 GMT

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

INTO is allowed only within a stored procedure you could instead rewrite the query as :

     SELECT CAST(CURRENT_DATE AS FORMAT 'YYYY-MM-DD') V_DATE1;

OR

     SELECT CAST(CURRENT_DATE AS FORMAT 'YYYY-MM-DD') AS V_DATE1;

Narayan

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