Home Page for the TeradataForum

Archives of the TeradataForum

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

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