CODEWITHSUNDEEP
datetalend
pika
pika

Reputation: 63

Date format in Talend "2006-05-27 17:00:00.000"

I am facing an issue with Talend dates. I have tried several solutions but still an "unparseable date" error persists.

My date format is of the form : "2006-05-27 17:00:00.000" Can you help me ?

Upvotes: 1

Views: 1441

Answers (3)

code
code

Reputation: 123

you should use this function in talend to fetch date: TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.SSS","2016-01-12 12:45:00.000")

Upvotes: 0

tobi6
tobi6

Reputation: 8239

If you don't handle the conversion yourself in a tMap but just want to use a schema, then: In your mapping configuration in the date field, you can add the following string:

yyyy-MM-dd HH:mm:ss.SSS

to set the correct format mapping for the date string. Otherwise the answer of garpitmzn is the way to go.

Upvotes: 1

garpitmzn
garpitmzn

Reputation: 1011

you can use below talendDate function to parse your string into date..

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.sss","2006-05-27 17:00:00.000")

this would take input as string and return you date.

Upvotes: 2

Related Questions