Archives of the TeradataForum

Message Posted: Thu, 12 Oct 2006 @ 19:55:43 GMT

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

Seems like adding 0.5 seconds and then casting the result to timestamp(0) should do the trick. (I'm assuming that casting to timestamp(0) rounds down, but you should look it up to be sure.)

Naomi

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