Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 22:41:41 GMT

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

This might work....maybe. I don't have a float field to test this that does not go out of date range, but this may work.

select cast( cast( cast(columnname as FORMAT '9999-99-99')
     as char(10) ) as date)

KRT

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