topic create a date "DD" with a tmap in Talend Studio

create a date "DD" with a tmap

Anonymous — Sat, 16 Nov 2024 14:25:12 GMT

hello i want to create a date with my tmap with the format 'DD'
exemple :
'24/08/1986' =>'24'
thank you
anaïs

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 10:43:30 GMT

please have a look to this screenshot because there is a really easy way to do it

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 14:26:40 GMT

i know i can do that but when i want to insert the date 'DD' into a table mysql
i can't insert it because in talend i have a date and in mysql i have a varchar(2) or varchar(4)

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 14:43:41 GMT

ok I didn't understand you question so the answer is :

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 15:39:21 GMT

I HAVE THIS ERROR in my job and i don't understand why:
Starting job agrement at 16:36 25/03/2008.
Exception in component tMap_1
java.lang.NullPointerException
at java.util.Calendar.setTime(Unknown Source)
at java.text.SimpleDateFormat.format(Unknown Source)
at java.text.SimpleDateFormat.format(Unknown Source)
at java.text.DateFormat.format(Unknown Source)
at routines.TalendDate.formatDate(TalendDate.java:33)
at test1.agrement.agrement.tOracleInput_1Process(agrement.java:1562)
at test1.agrement.agrement.runJobInTOS(agrement.java:2568)
at test1.agrement.agrement.main(agrement.java:2431)
Job agrement ended at 16:36 25/03/2008.

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 15:40:53 GMT

where the date value comes from? Can you give me a screenshot of your tmap configuration?
thanks?

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 16:38:44 GMT

this is the screenshot

Re: create a date "DD" with a tmap

Anonymous — Tue, 25 Mar 2008 22:22:29 GMT

Hi,
cahsohtoa's soultion is right. The problem is that you have null-values in your date. So change the code to the following:

row2.Date == null ? "" : TalendDate.formatDate("dd",row2.Date);

You should think about your default value if the Date is null. In this example just "".
Bye
Volker

Re: create a date "DD" with a tmap

Anonymous — Wed, 26 Mar 2008 08:46:48 GMT

i have also a null pointer exception with my tmap
Starting job agrement at 09:38 26/03/2008.
Exception in component tMap_1
java.lang.NullPointerException
at test1.agrement.agrement.tOracleInput_1Process(agrement.java:898)
at test1.agrement.agrement.runJobInTOS(agrement.java:1990)
at test1.agrement.agrement.main(agrement.java:1853)
Job agrement ended at 09:38 26/03/2008.
i have just changed the expression of my tmap with the date, it s strange because i have 4875 lines inserted in my table but the others lines aren't inserted

Re: create a date "DD" with a tmap

Anonymous — Wed, 26 Mar 2008 10:34:46 GMT

can i have some help please?

Re: create a date "DD" with a tmap

Anonymous — Wed, 26 Mar 2008 20:24:42 GMT

Is there any specialty on the other lines? Particularly null values in some attributes?