topic Re: [resolved] parseDate and "MMM" pattern in Talend Studio

[resolved] parseDate and "MMM" pattern

Anonymous — Sat, 16 Nov 2024 13:51:04 GMT

Hello all,
I found on Forum how to parse a date like "Jun 30 12 12:16:45"
so, I tried :

TalendDate.parseDate("MMM dd HH:mm:ss","Jun 30 12:16:45");

And finally this exception occurs:

Exception in component tJavaRow_6
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Jun 30 12:16:45"

I don't understand where is the problem... My pattern seams to be correct.
Thanks,

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Thu, 30 Jul 2009 20:34:57 GMT

Hi,
may be a problem with your locale. If it isn't set to English this wouldn't work i guess. Try to set a locale. I'm not sure but may be there is a method for parseDate which will allow a locale as parameter.
Bye
Volker

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Fri, 31 Jul 2009 03:36:37 GMT

Hello guy
Try

TalendDate.parseDateLocale("MMM dd HH:mm:ss","Jun 30 12:16:45","en");

Best regards

shong

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Fri, 31 Jul 2009 07:52:44 GMT

It was exactly the problem. If the locale isn't set, the date couldn't be parsed.
So, it's better to use directly parseDateLocal instead of a simply parseDate.
Thanks you!

Re: [resolved] parseDate and "MMM" pattern

_AnonymousUser — Fri, 20 Jan 2012 14:20:48 GMT

I ma tring to convert a date which is in string format to dd/mm/yyyy format.Please tell me the method in which i can do this

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Fri, 20 Jan 2012 14:58:30 GMT

TalendDate.parseDate("dd/mm/yyyy",Your Date);
This should parse your string to a date ..... also make changes to column where you are going to have this date,in Talend as well as in DB if you are passing it in DB.

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Sun, 10 Feb 2013 02:42:56 GMT

Hola a todos tengo el siguiente problema
utilizo la siguiente funcion
(row5.Fecha_Entr_Prog.equals("null"))? TalendDate.parseDateLocale("yyyy-MM-dd HH:mm:ss","2013-02-09","EN") : TalendDate.parseDateLocale("yyyy-MM-dd",row5.Fecha_Entr_Prog,"EN")
con el fin de evitar los null's pero cuando ejecuto la ETL me genera el siguiente error

java.lang.StringIndexOutOfBoundsException: String index out of range: 4
at java.lang.String.substring(Unknown Source)
si alguien me puede ayudar

Re: [resolved] parseDate and "MMM" pattern

_AnonymousUser — Mon, 11 Feb 2013 08:04:23 GMT

Try:
(Relational.ISNULL(row5.Fecha_Entr_Prog))? TalendDate.parseDateLocale("yyyy-MM-dd HH:mm:ss","2013-02-09","EN") : TalendDate.parseDateLocale("yyyy-MM-dd",row5.Fecha_Entr_Prog,"EN")

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Wed, 11 May 2016 11:27:12 GMT

Thankl you very much it work
TalendDate.parseDateLocale("EEE MMM d HH:mm:ss zzz yyyy", "Sun Mar 06 11:28:16 IST 2011","en")

Re: [resolved] parseDate and "MMM" pattern

Anonymous — Wed, 11 May 2016 11:45:54 GMT

Thankl you very much it work
TalendDate.parseDateLocale("EEE MMM d HH:mm:ss zzz yyyy", "Sun Mar 06 11:28:16 IST 2011","en")