Calculating no of months between 2 dates

Database

Calculating no of months between 2 dates

I need to find the number of months between 2 dates.. say how many months elapsed between today's date and '2008-06-06'

Can someone please help me.

Thanks in advance
3 REPLIES
Teradata Employee

Re: Calculating no of months between 2 dates

Hello,

You can do that using:

SELECT CURRENT_DATE - CAST('2008-06-06' AS DATE) MONTH(4);

Regards,

Adeel

Re: Calculating no of months between 2 dates

thanks Adeel.. that worked.

Re: Calculating no of months between 2 dates

Thanks Adeel....I was also searching for a function in Teradata which is similar to INTCK('MONTH' .... ) in SAS.