Archives of the TeradataForum

Message Posted: Fri, 06 Mar 2003 @ 21:04:54 GMT

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

When you are talking about "very large numbers" are you refering to something that wouldn't fit in an integer - such as 1.2e15? The following example generates an overflow - and hence a problem converting the float to an integer:

select 1.2e15 as f, cast (f as integer)

If you are trying to do this, you might need to consider a whole 'nother approach - such as some form of fixed point arithmetic. Could you be more specific as to the problem you are trying to solve? That may lead to a useful solution - especially if you can include some sort of "why you need to go down this path" info as well.

Glenn Mc

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