Extract Date,Month and Year in Tmap??????

[ankit7359]

Hi,

Can i extract date and month and year from a date ... in Tmap,..

How about dayno and weekno???

if yes,then how..???

Pls help 

thanks in advance.

Ankit

[Anonymous · Accepted solution]

Hi,

    It is quite easy. You will have to just change the format of the column having date. Please see the screenshots below.

The output of the above tmap is as shown below.

 You can refer all different options of Date from below link.

https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Hope I have answered your query. Could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi