Hi ,
In teradata - how to add timestamp column with Varchar column values
[SEL
PURCHASE_DATE,
WARRANTY,
Expiration_Date
FROM PRODUCT TABLE ]
Output :
[PUR_DATE(Timestamp) WARRANTY(Varchar) Expi_Date(Timestamp)
5/21/2012 14:00:00 24 ?? }
In Exp_Date column it should add both 5/21/2012 14:00:00 and 24 ---> 5/21/2014 14:00:00
Please guide me on this .
Thanks