topic Re: TalendParseDate error in Talend Studio

TalendParseDate error

Anonymous — Wed, 10 Jan 2018 09:24:53 GMT

Hi All ,

The below command is not working properly with YYYY and the same is working good with yyyy

TalendDate.parseDate("MMM dd YYYY",TalendDate.getDate("MMM dd yyyy")

TalendDate.parseDate("MMM dd yyyy",TalendDate.getDate("MMM dd yyyy")

Can someone suggest the purpose of YYYY and when can i use and why it is giving invalid result.

Thanks,

Bharath

Re: TalendParseDate error

Anonymous — Wed, 10 Jan 2018 09:41:18 GMT

Hi Bharat,

since java is case sensitive so YYYY does not work for it.

The date format always has dd MM yyyy .

Let me know more about your requirement.

Regards,

Neha

Re: TalendParseDate error

Anonymous — Wed, 10 Jan 2018 10:04:20 GMT

hi neha,

Here there is no requirement .both commands are working properly, but

YYYY is not giving correct result and yyyy is giving correct result,

may i know the reason why YYYY is not throwing error and giving junk value or any significance for YYYY

Re: TalendParseDate error

Anonymous — Wed, 10 Jan 2018 12:19:53 GMT

Hi,

Well I have faced error saying : Invalid character near 'Y' , whenever I have used YYYY by mistake in my date formats instead of yyyy.

Like for exmaple, M is always capital and d is always small in a date format ,similarly y is always small. It will simply not work with capital Y because its something in-built in java, as far as my knowledge is concerned.

I wish I could help you more in this by seeing any screen-shot and figure out the exact issue. let me know if I can solve more.

Thanks,

Neha

Re: TalendParseDate error

Anonymous — Thu, 11 Jan 2018 03:29:31 GMT

Hi,

"yyyy" stands for Year in Java Date. You can get date pattern from schema setting.

Please have a look at my screenshot.

Best regards

Sabrina

Re: TalendParseDate error

Anonymous — Wed, 17 Jan 2018 10:52:32 GMT

Hi ,

The command i posted, it is not throwing any parsing error and it is working fine and giving improper result.

Thanks,

Bharath

Re: TalendParseDate error

Anonymous — Wed, 17 Jan 2018 10:54:05 GMT

yyyy is stands for year and wat about YYYY and why it is not throwing error.

YYYY is giving result which is not correct result and the result for YYYY is on what basis caluclated.

Re: TalendParseDate error

cterenzi — Wed, 17 Jan 2018 15:11:10 GMT

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

According to the Java docs, 'Y' represents "Week Year" which is slightly different from 'y'.

This stackoverflow article goes into more detail:
https://stackoverflow.com/questions/8686331/y-returns-2012-while-y-returns-2011-in-simpledateformat

Re: TalendParseDate error

Anonymous — Thu, 18 Jan 2018 08:44:16 GMT

Hello,

Thanks for sharing the related docs with us.

Best regards

Sabrina