i need to extract the current year birthday date.
birthday column is yyyy-mm-dd hh:mm:ss:**bleep** type
ThisYearBirthday_Date = Dateadd(year,DATEDiff(year, BirthDate,GETDATE()),BirthDate)
ADD_YEAR (BirthDate, (cast(BirthDate as date)- cast(current_timestamp as date)) )????
any help please?
There's no ADD_YEAR or SUBTRACT_MONTH, because ADD_MONTHS covers all :-)
Add_Months(BirthDate, Cast((CURRENT_DATE - BirthDate YEAR) AS INT) * 12)
Of course this assumes that BirthDate is correctly defined as DATE, otherwise use CURRENT_TIMESTAMP instead of CURRENT_YEAR,
Btw, are both of you working in the same project?
Yes, we work in the same migration project:) And we have a very big luck to have you here!:)))
Do you know any conversion tool ? we used Ispirer - but it's not good at all
Teradata Professional Services uses a proprietary tool called the Teradata Migration Accelerator that automates script and stored procedure conversion as well as data movement from another platform (SQL Server/DB2/Oracle) to Teradata. Contact your Teradata representative for more information.