topic Re: Datetime parsing in Talend Studio

Datetime parsing

Anonymous — Sat, 16 Nov 2024 02:45:53 GMT

I am getting errors when I am trying to map a string field containing datetime data(from csv) from source to the final table using tmap.

I attach the screen shots below of the same.

I am using talend.dateparse function for getting the desired result but its showing unparseable date. The time stamp is not getting parsed and is throwing runtime error.

Please help resolve this issue.

Re: Datetime parsing

billimmer — Tue, 07 Apr 2020 22:36:33 GMT

Here is an example of converting a string to a date

TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyyMMdd",row1.Created_Date))

The string in the example is row1.Created_Date. Modify the example with your formatting.

Re: Datetime parsing

Anonymous — Wed, 08 Apr 2020 04:35:07 GMT

Hi Billimmer

I need to convert from string to datetime format (i.e yyyy-mm-dd hh:mm:ss
format ) to the target table in mysql database.

It would be great if you could help me in this regard.

Thanks & Regards
Tryambak De

Re: Datetime parsing

Anonymous — Wed, 08 Apr 2020 04:45:19 GMT

Hi
Change the expression to:
TalendDate.parseDate("dd/MM/yyyy HH:mm:ss")

//HH: hours in day (00-23), hh: 12 hours AM or PM (00-12)

Regards
Shong

Re: Datetime parsing

Anonymous — Wed, 08 Apr 2020 05:11:07 GMT

Hi Shong

I did this but its giving me unparasable error for the time part.

Thanks & Regards
Tryambak De

Re: Datetime parsing

manodwhb — Wed, 08 Apr 2020 05:38:05 GMT

Can you share some sample data for that field which you were trying to convert string to date.

Re: Datetime parsing

Anonymous — Wed, 08 Apr 2020 09:00:07 GMT

Hi Manodwhb

Please find attached the sample data set.

Thanks & Regards
Tryambak De

Re: Datetime parsing

manodwhb — Wed, 08 Apr 2020 09:02:55 GMT

I am not able to find sample data set.

Re: Datetime parsing

Anonymous — Wed, 08 Apr 2020 09:07:38 GMT

Hi Please find the sample data set attached.

Attendance_Dtls.csv

Re: Datetime parsing

manodwhb — Wed, 08 Apr 2020 10:50:47 GMT

Open the csv file in some editor like notepad++ and check the date format for that column and specify that format in the above @shong expression.

Re: Datetime parsing

Anonymous — Wed, 08 Apr 2020 11:05:50 GMT

Hi
I just made a testing: read the sample file using tFileInputDelimited, convert the string to a Date using expression
TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row2.Swipe_In_Time)
tFileInputDelimited--main--tMap--tLogRow

The job runs fine.

Regards
Shong