Calculating time difference between 2 dates in Teradata
<p>I'm trying to calculate time difference (in months) between the current date, and the date the customer opened his account (only for those who joined in January 2012).<br>
I try to use <code>current_date</code> and <code>cast</code>, but I think my problem is in my date field which is in the following format: <em>dd/mm/yyyy</em><br>
I'm working on Teradata.<br>
Your help will be appreciated. </p>