Archives of the TeradataForum

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

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

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>>