Archives of the TeradataForum
Message Posted: Fri, 02 Nov 2012 @ 14:02:33 GMT
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.
Thanks in advance,
Sughesh I S.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|