Archives of the TeradataForum

Message Posted: Mon, 02 Jun 2003 @ 19:01:06 GMT

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

Well, I have never seen these functions on teradata, but with my ODBC in Queryman floor(x)=cast(x as integer) and ceil(x)=cast(x+0.5 as dec(8,0)) works maybe it is not the best thing in terms of performance but it works.

Hope that helps

Markus

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