Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 15:27:53 GMT

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

You can cast the TIMESTAMP field to DATE :

Select Cast(timestamp_field as DATE) From table

- Rishi

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