Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2005 @ 09:17:44 GMT


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


Subj:   Re: Writing UDF for Numeric Datatypes
 
From:   Alexander T

Thanks for the suggestion but what i really want is

1) If we have a numeric datatype whose precision is dynamic mean to say it can be of type Numeric(10,4) or Numeric(18,8) and get the values in varchar.

For eg : if the value in the numeric column of (10,4) is 123.45 then the resultant should be 123.45 not 123.4500 and if the value was 125 then the resultant should be 125 and not 125.0000.

The problem here is since the precision is dynamic, what i can do is trim(cast(column as varchar(18))).


Regards

Alexander



     
  <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: 15 Jun 2023