How can i add year to a date and month value

Seven Stars

How can i add year to a date and month value

Hello,

 

kindly suggest i am having a column where my input looks like 7-Jan but i need output as 7/1/2019(current year),how can i achieve this.

 

Regards,

Meena

Four Stars

Re: How can i add year to a date and month value

Please try like this :

 

 select to_char(to_date('07-Jan' || '-' || extract(year from sysdate),'DD-MON-YYYY'),'DD/MM/YYYY') from dual ;

Highlighted
Thirteen Stars

Re: How can i add year to a date and month value

@muralam,i will suggest you to create a new filed in tmap by using var as a sting with -2019 and concatenate the source field with variable field and then convert to sting to data.

Manohar B

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.