Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: SQL: integer part of a float_field
From:   McCall, Glenn D

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020