Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 13:10:50 GMT

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

Hi Neeraj,

try

SELECT * FROM tablex
WHERE colx (FORMAT 'YYYY/DD/MM') IN ( '2000/01/01', '2001/01/01') );

Dieter

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