|
Archives of the TeradataForumMessage Posted: Fri, 02 Nov 2012 @ 14:02:33 GMT
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.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||