Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2011 @ 16:17:47 GMT

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

Try using:

     Between '2010-06-01 10:10:01' And '2010-06-30 11:00:59'

Or

     Between Timestamp '2010-06-01 10:10:01' And Timestamp '2010-06-30 11:00:59'

And DO NOT specify invalid dates such as June 31st.

Mike Dempsey
Teradata Client Tools

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