topic Re: how delete time from date in Talend Studio

how delete time from date

hechmi — Sat, 15 Sep 2018 12:20:15 GMT

Hello
i have a probleme to convert a date :
2011-08-19 15:00:10.
in this format :
2011-08-19

how to delete time from date 2011-08-19 ~~15:00:10.~~

best regards

Re: how delete time from date

vapukov — Sun, 16 Sep 2018 09:32:54 GMT

depend from what You have and what want to have:

- is it string or date?

- is target must be string or date?

all around - formateDate/parseDate/substring

all 3 function You can find in tMap build expression

Re: how delete time from date

rnathan2020 — Sun, 16 Sep 2018 19:41:56 GMT

TalendDate.formatDate(pattern, date) is the function you want. If you want TalendDate.formatDate("yyyy-mm-dd", myDateColumn) should give you want you want.

Re: how delete time from date

hechmi — Sun, 16 Sep 2018 21:35:10 GMT

hi @vapukov

thank you for your answer ,

type of input is format date 'dd-MM-yyyy HH:mm:ss' i want to have in out date but without time 'dd-MM-yyyy

any help for this problme

best regards

Re: how delete time from date

rnathan2020 — Sun, 16 Sep 2018 21:39:20 GMT

@hechmi wrote:

hi @vapukov

thank you for your answer ,

type of input is format date 'dd-MM-yyyy HH:mm:ss' i want to have in out date but without time 'dd-MM-yyyy

any help for this problme

best regards

Hi, what I gave you was an example. You can ask for any format you want, keeping in mind how to represent it. Here is a link that might help. You can also google for java date format conversion.

Re: how delete time from date

Anonymous — Sun, 16 Sep 2018 22:16:16 GMT

@hechmi do you know the type of data you are working with? Is it a String (text) or is it a Date (essentially a number representation of a date)? If you are not sure, can you take a screenshot of the schema you are using and post it. Without this information, it is not possible to tell you how to solve this.

Re: how delete time from date

hechmi — Sun, 16 Sep 2018 22:47:18 GMT

@rhall

i have date_transaction time in source data 'dd-MM-yyyy hh:mm:ss' 'input' i want will have date_transaction out put without time 'dd-MM-yyyy'

you can see attached pic

best regards

data_source_input.PNG
date_want_out.PNG

Re: how delete time from date

vapukov — Sun, 16 Sep 2018 23:51:20 GMT

@rnathan wrote:
TalendDate.formatDate(pattern, date) is the function you want. If you want TalendDate.formatDate("yyyy-mm-dd", myDateColumn) should give you want you want.

unfortunately - not always correct

formateDate return string
 @return the formatted time string.

this is why we ask - what format of column

in some cases it not important, but in some could be

1) if it DateTime to Date, all what need todo - just use proper format in tMap

2) if it string to string - just use substring for first 10 characters 🙂

3) for proper datetime to date convertios, need use use construction like

TalendDate.parseDate("dd-MM-yyyy",TalendDate.formatDate("dd-MM-yyyy HH:mm:ss",myDate))

Re: how delete time from date

Anonymous — Mon, 17 Sep 2018 09:52:26 GMT

I get the impression that you are new to this. When I asked for the schema, I meant the column types. What you have given does not give me anymore clues to what you need. The only way this can be resolved for you is if you can let us know whether the date is stored as a String (text) or a Date (an object that holds dates). To check this, go to your source component and open up the schema for that. Take a screenshot and post it here. Once you do that an easy answer can be supplied

Re: how delete time from date

hechmi — Mon, 17 Sep 2018 11:01:53 GMT

hi @rhall

date source type datetime '2010-10-16 00:00:00' i want convert to simple date '2010-10-16'

best regards

date_want_out.PNG

Re: how delete time from date

hechmi — Mon, 17 Sep 2018 11:42:33 GMT

hi;
thak you i resolt this problem ,
i was modified in shema able source datetime -->date
bst regards

Re: how delete time from date

Anonymous — Mon, 17 Sep 2018 11:56:33 GMT

OK, that tells me that your Talend data type/class was Date.

Re: how delete time from date

hechmi — Mon, 17 Sep 2018 12:03:50 GMT

hi @rhall
i have other question
i try with this example inthis link but i have a problem i put screen

http://diethardsteiner.blogspot.com/2012/02/talend-open-studio-populating-date.html

erreur.PNG

Re: how delete time from date

Anonymous — Mon, 17 Sep 2018 12:23:54 GMT

Your code is trying to do something to an object which is null. You will need to show your actual code for this. I suspect that maybe you are not getting dates for every row.

Re: how delete time from date

vapukov — Mon, 17 Sep 2018 12:27:20 GMT

@rhall - is right

many functions - string, date, double fail with error if argument is null
so, You need check - all function what You have in tMap, and handle null for them