Trouble loading date using talend

[Anonymous]

Hi,

I have a trouble while loading date of value '01-01-0001 00:00:00' and '01-01-4712 00:00:00' into my Database with Talend as the ETL tool. Talend is not recognizing the format as date but considering it a string.  When I explicitly convert the string to date format(MM-dd-yyyy HH:mm:ss), the job building is popping out an error "Cannot convert value to date". Can anyone help me with this?

Thanks in advance,

Ramya.

[Anonymous]

Hi Ramya,

     Could you please share your job screenshot and the component where you are mapping the date in correct format? End of day, Talend is a Java code generator. I could see that the dates have mentioned is getting converted from string to date properly in Talend tMap. 

The function used is as below.

TalendDate.parseDate("dd-MM-yyyy", "01-01-4712")

If your data is already in date format, you can skip this conversion step and can directly map them.

I do not have a Redshift DB handy right now. So more screenshots of your overall flow will help us to analyse further.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Team,

Thank you for your suggestions.

My value is already a date. So, I reckon parsedate function doesnot work out.

I didn't perform any conversions. Also didn't use any tmap. Still, we are faing error converting value to date error. 

Thanks, 

Ramya.

[manodwhb]

@rchinta ,what error are you getting? if you are sure and want to convert one date format to another date format,just use tconverttype to convert the one date to other date or sting to date and let me know the error?