null in dateparser (tmap)

[Anonymous]

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 

[Anonymous]

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

[ashokpokhriyal]

thanks this helped me.