Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Nov 2012 @ 14:02:33 GMT


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


Subj:   Subtraction between dates
 
From:   sughesh iyyani

Hi Experts,

Kindly let me know how can we subtract two date fields and required output should get in number of days.

I tried "Select '2012-02-20' - '2012-02-10' ", then is giving proper output.

But as it crossed a month interval, its giving output as integer like MMDD.

Example :- Select '2012-03-10' - '2012-02-05' giving output as 105, means 1 month and 5 days.

Kindly let me know how can I get result as this many days difference.

Also let me know how to do subtraction of 45 days from a date column.

As 45 days won't come with in a month, its always giving integer.

Kindly advise.


Thanks in advance,

Sughesh I S.



     
  <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