Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2008 @ 10:26:09 GMT


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


Subj:   How to Achieve the decimal part
 
From:   sreenivasa.akula

Hi,

In Oracle MONTHS_BETWEN() will give result in fractions like xx.yyyy I am trying to calculate months between two dates in teradata but I unable get the fraction value i.e simply its giving xx but can we get the result in fractions in TD .

I can get the months in days and we can divide it with 30 we will get some approximate value but its not accurate.

So Please help on this with any alternative way


Thansk in Advance.



     
  <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