DATE DATA TYPE (UNPARSED DATE ERROR)

[Anonymous]

hi all,
i am new to talend
My sourece is csv, there in date column i have date date in "MM/DD/YYYY" pattern,
when tried that to load in staging table . I am getting the error "UNPARSED DATE"
My db is oracle here defaoult pattern is dd-mm-yyyy, i tried talend.parsedate in tmap also
any help.....

[Anonymous]

How does you schema look like? is the datatype of the field set to date?

[Anonymous]

hi,
Yes, datatype field set as Date

[Anonymous]

Did you define the date-pattern in the schema of tOracleOutput?
you can modify this by pressing ctrl-space in, see my screenshot for an example.

[Anonymous]

Hi,
I can't find your screen shot.
But between file and staging table i am using Tschemacompliancechaeck component
to check the datatype, so all the records stopped there itself...and it shows that Unparseable date: "5/31/2011"

[Anonymous]

Click on "Edit Schema" on your input component (tFileInputDelimited?).

[Anonymous]

Hi,
In my (tFileInputDelimited ) Schema i have date pattern like this "MM-dd-YYYY", but in my source file its like MM/dd/yyyy-5/31/2011

[Anonymous]

Hi,

Just change date pattern in edit schema menu. If the date is in the format "MM/DD/yyyy", you should set date pattern to "MM/DD/YYYY" (for the input file). For writing in a db table in format "MM-dd-YYYY", just edit the tDb_nameOut component schema and set date pattern there to "MM-dd-yyyy".

[Anonymous]

*note, for this to work you have to read the date correctly from input(date column should be of date type, not string type for the schema of your file input)

[Anonymous]

Hi,
I need to change MM/dd/YYYY to dd-MM-YYYY
MM/dd/YYYY---this format in source file
dd-MM-YYYY-- this is in output table , so as you said i changed in schema still it showing error