How to convert string to date

Four Stars

How to convert string to date


How to convert string whose value is "29-JUN-2018" (including double parenthesis in its value) to date format? 
The expected format is "yyyy-MM-dd'T'hh:mm:ss.SSS"

Eleven Stars

Re: How to convert string to date

first tmap split your string in 3 parts
second Tmap change Jun to 06
third Tmap convert 20180629 to dat then format this Date
TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyyMMdd", 20180629 ))

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Six Stars

Re: How to convert string to date

mapping.PNGparse.PNGtmap.PNGout.PNG

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads