Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Oct 2006 @ 19:55:36 GMT


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


Subj:   Question about Oracle ROUND() function UDF
 
From:   Sagarwala, Ajith

I am looking for a UDF which is similar to Oracle round() function. I do not want to turn RoundHalfwayMagUp to TRUE in DBSControl but instead would like to allow certain groups of users use the round UDF for their data rounding needs.

Anyone aware of this ?

................................................................

In Teradata

     select cast(0.25 as decimal(15,1)) = 0.2

     select cast(0.26 as decimal(15,1)) = 0.3

In Oracle

     select round(0.25,1) from dual = 0.3


     
  <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