Archives of the TeradataForum

Message Posted: Mon, 05 Nov 2012 @ 15:29:59 GMT

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

The preferred syntax for this operation is:

     select date '2012-02-20' - date '2012-02-10';

The word 'date' followed by a character string in 'yyyy-mm-dd' format is standard ANSI syntax for a date.

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