Archives of the TeradataForum

Message Posted: Sat, 16 Mar 2003 @ 01:55:27 GMT

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

Anyone willing to share "production" sql logic on how to calculate a customer tenure in months from a teradata table?

customer#     install date        reporting date     tenure (in months)

123456         1/1/2002             1/31/2003            12
12345666       2/15/2002            1/31/2003            11

My first thougt was to use "extract(month" and "extract(year" between the two dates and then doing the math.

Any help would be greatly appreciated.

Thanks,

Bruce

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