How can i add year to a date and month value

[muralam]

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

[RajeevKumarMeh]

Please try like this :

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

[manodwhb · Accepted solution]

@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.

[manodwhb]

Hi @muralam ,

If the answer has helped you,could you please mark the topic as resolved?