Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Apr 2008 @ 22:40:19 GMT


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


Subj:   Re: DECIMAL(19,2) to DECIMAL(18,2) type casting
 
From:   Michael Larkins

Hi Lilian:

Here what I think might be happening:

The normal output data type from AVG is float. As far as I have seen, it is the only place where the data type coming out is not the same as the data type going into it.

On the second one, you are converting/forcing the float to a decimal attribute and getting more accuracy with the .25 versus the .00.


Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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: 27 Dec 2016