null in dateparser (tmap)

Anonymous — Sat, 16 Nov 2024 04:58:01 GMT

Hi,

i want to convert from string with this value "yyyy-MM-dd' 'HH:mm:ss" to date "yyyy-MM-dd' 'HH:mm:ss". but i have this error:

java.lang.NullPointerException
	at routines.system.FastDateParser$DateParser.parse(FastDateParser.java:127)
	at java.text.DateFormat.parse(Unknown Source)
	at routines.TalendDate.parseDate(TalendDate.java:928)
	at routines.TalendDate.parseDate(TalendDate.java:886)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.tDBInput_1Process(ODS_Collecte_Preparation_licence_info_1.java:4563)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.runJobInTOS(ODS_Collecte_Preparation_licence_info_1.java:7607)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.main(ODS_Collecte_Preparation_licence_info_1.java:7282)
Exception in component tMap_2 (ODS_Collecte_Preparation_licence_info_1)
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "null"
	at routines.TalendDate.parseDate(TalendDate.java:942)
	at routines.TalendDate.parseDate(TalendDate.java:886)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.tDBInput_1Process(ODS_Collecte_Preparation_licence_info_1.java:4563)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.runJobInTOS(ODS_Collecte_Preparation_licence_info_1.java:7607)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.main(ODS_Collecte_Preparation_licence_info_1.java:7282)
Caused by: java.text.ParseException: Unparseable date: "null"
	at java.text.DateFormat.parse(Unknown Source)
	at routines.TalendDate.parseDate(TalendDate.java:928)
	... 4 more

do you have a picture with my tmap best regards

Re: null in dateparser (tmap)

Anonymous — Thu, 15 Aug 2019 23:30:28 GMT

Hi,

Could you please remove the single quotes and parse the date?

Relational.ISNULL(row2.data)? null:
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row2.data)

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

Re: null in dateparser (tmap)

ashokpokhriyal — Wed, 18 Sep 2024 10:00:28 GMT

thanks this helped me.

topic Re: null in dateparser (tmap) in Talend Studio

null in dateparser (tmap)

Re: null in dateparser (tmap)

Re: null in dateparser (tmap)