Converting UAT (Date)

[karlis_peterson]

I am a newbie to PDI. I am quering a database and grabbing data that has a following timestamp format:

TIMERECORDED
1335429814

I want to be able to take the value above and then add 5 minutes. I will query the DB every 5 minutes and take 5 minute samples of data.

What is the best method to handle coverting the date in a step? Calculator?

Thanks in advance.

[darrell.nelson]

Well, I'm not exactly sure what you're driving at but dates and times can easily be manipulated with the Java Calendar.

var date_recorded;
var date_plus_5min;

/*
 * Obtain an instance of the default Java Calendar.
 */
cal = java.util.Calendar.getInstance();

/*
 * Set the calendar to the recorded time.
 */
cal.setTimeInMillis(TIMERECORDED * 1000);
date_recorded = cal.getTime();

/*
 * Add 5 minutes.
 */
cal.add(java.util.Calendar.MINUTE, 5);
date_plus_5min = cal.getTime();

The preview of the result will look something like this:

timerecorded.jpg

[karlis_peterson]

Sorry my post was confusing. So this is EXACTLY what I wanted to accomplish. I wanted to convert the time and I will play with your sample. Thanks for the response.

[darrell.nelson]

It wasn't so much confusion as it was skepticism. The TIMERECORDED value of 1335429814 represents the number of seconds since Midnight, January 1, 1970 (the unix epoch). Thus, adding 5 minutes could be as simple as adding 300 (seconds) to that value.

Personally, I prefer the Java Calendar method to do my date/time manipulations because it handles things like Leap Years, Time Zones, and Locales.

[gutlez]

It can also be accomplished in the Calculator step.
I generally recommend people stay away from the Modified JavaScript Values step whenever possible.

[darrell.nelson]

gutlez is right! I didn't know the Calculator step would do that.

time_recorded_2.jpg
time_calculator.jpg

[karlis_peterson]

Darrell -

I used the calculator per your example. This is the way to go. Thanks for taking the time to upload the screenshot. Very helpful!