Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 18:21:46 GMT

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

You don't need DUAL in Teradata and SQL Server.

You can say SELECT CUURENT_DATE;

Because the FROM clause is NOT mandatory as in Oracle, you don't need DUAL.

-Ganga Palakattil

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