[resolved] UnParseable Date format

[_AnonymousUser]

Can someone get me right date format pattern for the below date style. I get this format in my XML feed and find a right pattern.
"2013-09-26T00:00:00-05:00"
"2014-09-26T00:00:00-05:00"
"2015-09-26T00:00:00-05:00"

Thanks

[Anonymous]

Naju,
Try removing the ; from your expression.
Note: you also have to make sure that your row1.Date_TimeZone follows that exact time pattern.
Can you post an example of a row1.Date_TimeZone value that you are using?

[_AnonymousUser]

Hi,
I am using file delimited txt file and made a row map with db connection using tmap.
I have on column of data type string contains value like this "28-OCT-10"
so my query is how can i parse it to valid date format
to be inserted into the database

[alevy]

TalendDate.parseDate("dd-MMM-yy",<row.col>)

[Anonymous]

Hi I am getting Unparseable date: "Start_Date__c".
And in failure file I am getting
'09/09/2011' is not a valid value for the type xsd:date tart_Date__c --
this error please help me

[Anonymous · Accepted solution]

Can someone get me right date format pattern for the below date style. I get this format in my XML feed and find a right pattern.
"2013-09-26T00:00:00-05:00"
"2014-09-26T00:00:00-05:00"
"2015-09-26T00:00:00-05:00"

Thanks

I use pattern "yyyy-MM-dd'T'HH:mm:ss.SSSXXX" for XML date with miliseconds and timezone, without miliseconds it should be "yyyy-MM-dd'T'HH:mm:ssXXX"

[Anonymous]

Hi all,

i have tried all the suggestions from the comments  and still facing the issue.

I am getting the DateTime values from xml as (2019-01-13T11:35:28-05:00).

Unable to load this value directly, when loaded as string unable to convert this value from stringToDate.

Please suggest a solution or date pattern for this kind of value.