Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 17:46:56 GMT

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

<-- Anonymously Posted: Friday, September 29, 2006 11:49 -->

Response:

This might be opportunity to earn some consulting fee??

Try the following:

     select cast(cast(timestamp'2006-01-01 10:56:00' as date) as timestamp(0));

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