Talend community forum / How to take a day from a date as a string and month to ?

ead · 2008-11-10 09:11:00

Tags: [context, date, day, month, parsing]

Hi
I have a "date" cell in my table.
I want to take the day in the week from it as a string - means "sunday, monday,..."
And not as a number.
How can it be done?

And the same goes for the month (January and so on)

cahsohtoa · 2008-11-10 09:48:01

you can use this routine

public static String getDaysOfWeek(java.util.Date myDate) {

String theDay="";
String [] allDays = {"","SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"};

java.util.Calendar cal1 = java.util.Calendar.getInstance();
cal1.setTime(myDate);

theDay=allDays[cal1.get(java.util.Calendar.DAY_OF_WEEK)];

return theDay;
}

ead · 2008-11-10 09:50:49

oh, and where to put it so I can use it with my tMap object ??

cahsohtoa · 2008-11-10 10:09:42

you can create a routine in Repository>Code>Routine for exemple MyRoutine and copy/paste

public static String getDaysOfWeek(java.util.Date myDate) {

String theDay="";
String [] allDays = {"","SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"};

java.util.Calendar cal1 = java.util.Calendar.getInstance();
cal1.setTime(myDate);

theDay=allDays[cal1.get(java.util.Calendar.DAY_OF_WEEK)];

return theDay;
}

in place of

public static void helloExample(String message) {
if (message == null) {
message = "World";
}
System.out.println("Hello " + message + " !");
}

In your tMap

you can use it in a field using MyRoutine.getDaysOfWeek(row1.mydate)

ead · 2008-11-10 10:19:21

Thanks!
Work like a charm,
I guess the same thing goes for month?
public static String getMonth(java.util.Date myDate) {

String theMonth="";
String [] allMonths = {"","JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","JULY", "AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER"};

java.util.Calendar cal1 = java.util.Calendar.getInstance();
cal1.setTime(myDate);

theMonth=allMonths[cal1.get(java.util.Calendar.MONTH_OF_THE_YEAR)];

return theMonth;
}

Last edited by ead (2008-11-10 10:20:03)

cahsohtoa · 2008-11-10 10:26:45

yes It will work fine

Announcement

Unanswered posts

#1 2008-11-10 09:11:00

How to take a day from a date as a string and month to ?

#2 2008-11-10 09:48:01

Re: How to take a day from a date as a string and month to ?

#3 2008-11-10 09:50:49

Re: How to take a day from a date as a string and month to ?

#4 2008-11-10 10:09:42

Re: How to take a day from a date as a string and month to ?

#5 2008-11-10 10:19:21

Re: How to take a day from a date as a string and month to ?

#6 2008-11-10 10:26:45

Re: How to take a day from a date as a string and month to ?

Board footer