Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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