Talend community forum / Split a date range

dom · 2009-08-06 11:24:06

Hello,

I need to split a date rage into days. Per example:

I read from the database:

| Application | Start | stop
+-------------+---------------------+-----
| App1 | 2009/08/03 10:00 | 2009/08/05 12:15

And I need to split this line into something like this

| Application | Start | stop
+-------------+---------------------+-----
| App1 | 2009/08/03 10:00 | 2009/08/05 23:59
| App1 | 2009/08/04 00:00 | 2009/08/04 23:59
| App1 | 2009/08/05 00:00 | 2009/08/05 12:15

Can some one help me?

many thanks
Dominique

shong · 2009-08-06 11:55:43

Hello Dominique
It is possible to finish it in Talend, I will give you an example later, just want to confirm if you write a error output.
| App1 | 2009/08/03 10:00 | 2009/08/05 23:59 ??
i think it is
| App1 | 2009/08/03 10:00 | 2009/08/03 23:59
right?
Best regards

shong

dom · 2009-08-06 12:44:36

Hello shong,

it's not an error, I write the date in a "french" format. The pattern is "YYYY/MM/DD HH:MM"

The goal is to build reports of the use of various applications. My problem is when the application is used more than one day. Per exemple monday, at work, I open Outlook and I close the application friday. If I do a "close date - start date", I get a big usage one day and nothing other days of the week. Does you understand what I will do?

Sorry for my bad english

best regards
Dominique

Announcement

Unanswered posts

#1 2009-08-06 11:24:06

Split a date range

#2 2009-08-06 11:55:43

Re: Split a date range

#3 2009-08-06 12:44:36

Re: Split a date range

Board footer