Archives of the TeradataForum

Message Posted: Tue, 25 Feb 2003 @ 19:15:42 GMT

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

How about...

      EXTRACT ( MONTH FROM A.FLT_ORIG_DT)  between 9 and 12
AND   EXTRACT ( YEAR FROM A.FLT_ORIG_DT) = 2002

...or...

      EXTRACT ( MONTH FROM A.FLT_ORIG_DT) >= 9
AND   EXTRACT ( YEAR FROM A.FLT_ORIG_DT) = 2002

...or...

      EXTRACT ( MONTH FROM A.FLT_ORIG_DT) in (9,10,11,12)
AND   EXTRACT ( YEAR FROM A.FLT_ORIG_DT) = 2002

Dave

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