Archives of the TeradataForum
Message Posted: Fri, 26 Mar 2004 @ 22:41:41 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|