Date and Time Format With HH24

[Anonymous]

Hi
I have input Date coming with "18/APR/91 16:00:00" from oracle , I need to load the into Postgresql table
YEAR
MONTH
DATE
HOUR
each have separately column, and I'm using following method.

TalendDate.getPartOfDate("YEAR",row1.PSTART)
TalendDate.getPartOfDate("MONTH",row1.PSTART)
TalendDate.getPartOfDate("DAY_OF_MONTH",row1.PSTART)
TalendDate.getPartOfDate("HOUR",row1.PSTART)
Im getting following result
YEAR = 1991
MONTH = 3
DATE = 18
HOUR = 4
but we expecting result should be
YEAR = 1991
MONTH = 4
DATE = 18
HOUR = 16
Please let me know..
Thanks
Rajesh G

[Anonymous]

Thanks for that....
I did import all java util as well.. Please find code here.. after that also still its not working...
I'm unable import custom routine into my Talend Job which you sent thru email...
I did following method to import the your custom routine
Correct me If worng:-
Code > Routines > Right-click Routines and selected Import items > Select archive file path >

Please let me know..

// ============================================================================
//
// Copyright (c) 2005-2011, Talend Inc.
//
// This source code has been automatically generated by_Talend Open Studio for Data Integration
// CodeGenerator version 5.0.1.r74687
// You can find more information about Talend products at www.talend.com.
// You may distribute this code under the terms of the GNU LGPL license
// http://www.gnu.org/licenses/lgpl.html).
//
// ============================================================================
package routines;

import java.util.Calendar;
import java.util.Date;


public class DateFunction {
/**
* helloExample: not return value, only print "hello" + message.
*
*
* {talendTypes} String
*
* {Category} User Defined
*
* {param} string("world") input: The string need to be printed.
*
* {example} helloExemple("world") # hello world !.
*/
public static int getPartOfDate(String partName, Date date) {
if (partName == null || date == null)
return 0;
int ret = 0;
String[] fieldsName = { "YEAR", "MONTH", "HOUR", "MINUTE", "SECOND", "DAY_OF_WEEK", "DAY_OF_MONTH", "DAY_OF_YEAR",
"WEEK_OF_MONTH", "DAY_OF_WEEK_IN_MONTH", "WEEK_OF_YEAR", "TIMEZONE", "HOUR OF DAY" };
java.util.List<String> filedsList = java.util.Arrays.asList(fieldsName);
Calendar c = Calendar.getInstance();
c.setTime(date);
switch (filedsList.indexOf(partName)) {
case 0:
ret = c.get(Calendar.YEAR);
break;
case 1:
ret = c.get(Calendar.MONTH);
break;
case 2:
ret = c.get(Calendar.HOUR);
break;
case 3:
ret = c.get(Calendar.MINUTE);
break;
case 4:
ret = c.get(Calendar.SECOND);
break;
case 5:
ret = c.get(Calendar.DAY_OF_WEEK);
break;
case 6:
ret = c.get(Calendar.DAY_OF_MONTH);
break;
case 7:
ret = c.get(Calendar.DAY_OF_YEAR);
break;
case 8:
// the ordinal number of current week in a month (it means a 'week' may be not contain 7 days)
ret = c.get(Calendar.WEEK_OF_MONTH);
break;
case 9:
// 1-7 correspond to 1, 8-14 correspond to 2,...
ret = c.get(Calendar.DAY_OF_WEEK_IN_MONTH);
break;
case 10:
ret = c.get(Calendar.WEEK_OF_YEAR);
break;
case 11:
ret = (c.get(Calendar.ZONE_OFFSET)) / (1000 * 60 * 60);
break;
case 12:
ret = c.get(Calendar.HOUR_OF_DAY);
break;
default:
break;
}
return ret;
}
}

[Anonymous]

Hi
Finally, I know the root reason.
It should be DateFunction.getPartOfDate("HOUR OF DAY",row1.PSTART).
What you typed is DateFunction.getPartOfDate("HOUR_OF_DAY",row1.PSTART).
Regards,
Pedro

[Anonymous]

Sorry for troubling you..again Im getting same issue.
Im getting value instead of 16 HOUR = 0
Now I have used DateFunction.getPartOfDate("HOUR OF DAY",row1.PSTART) even same issue.
I checked the internet as well for "java.util.calendar" example
they are using "Calendar.HOUR_OF_DAY", same thing when i was using I'm not getting correct result.
Please find the link here..
http://www.roseindia.net/java/beginners/calendarexample.shtml
http://www.leepoint.net/notes-java/other/10time/30calendar.html
http://www.idevelopment.info/data/Programming/java/date/CalendarExample.java
http://www.leepoint.net/notes-java/other/10time/30calendar.html
Please let me know..
Thanks
Rajesh G

[Anonymous]

Hi Rajesh
Sorry. The expression is correct. The custom routine is correct. I think I must miss some detail.
You'd better check it carefully.
Or send me an email with this export job and custom routine.
I will test it for you.
Regards,
Pedro

[Anonymous]

Thanks Pedro..
I have send you the export ETL job and custom routine to your email.
Please have a look and let me know..
Thanks
Rajesh G

[Anonymous]

Hi Rajesh
This only error I find is "HOUR OF DAY" as the following image.
Regards,
Pedro

[Anonymous]

Thanks...Sorry again...
In custom routine i have declared like this..
case 12:
ret = c.get(Calendar.HOUR_OF_DAY);
break;
then, If use DateFunction.getPartOfDate("HOUR OF DAY",row1.PSTART) either this or that
OR
DateFunction.getPartOfDate("HOUR_OF_DAY",row1.PSTART)
Im getting same issue.
Im getting value instead of 16 HOUR = 0
Thanks
Rajesh G

[Anonymous]

Hi
"HOUR OF DAY" or "HOUR_OF_DAY" is decided by the code below.

String[] fieldsName = { "YEAR", "MONTH", "HOUR", "MINUTE", "SECOND", "DAY_OF_WEEK", "DAY_OF_MONTH", "DAY_OF_YEAR",
                "WEEK_OF_MONTH", "DAY_OF_WEEK_IN_MONTH", "WEEK_OF_YEAR", "TIMEZONE", "HOUR OF DAY" };

You will see the last element of this String array.
Sorry. I can't find out why it doesn't work...
I am really eager to fly to your side...
Regards,
Pedro

[Anonymous]

Thanks for your kind inputs and reply's...
Its working fine now...I did mistake when declare the strings
String[] fieldsName = { "YEAR", "MONTH", "HOUR", "MINUTE", "SECOND", "DAY_OF_WEEK", "DAY_OF_MONTH", "DAY_OF_YEAR", "WEEK_OF_MONTH", "DAY_OF_WEEK_IN_MONTH", "WEEK_OF_YEAR", "TIMEZONE", "HOUR_OF_DAY" };
We should declare "HOUR_OF_DAY" , but i was declaring "HOUR OF DAY" ... that y the problem...
Thanks very much..
Thanks
Rajesh G

[Anonymous]

Hi Rajesh
Great!
Feel free to ask any questions about Talend here.
Regards,
Pedro