In Rational Insight, how do I add hours to a timestamp?

Andrew Trobec

(497●13●144●139) Feb 05 '14, 9:25 a.m.

Hello,

I am extracting timestamps for work item actions in Insight from Europe with a server that is on the US east coast, giving me a 6 hour difference. I want to extract the data with respect to CET, so how do I add 6 hours to each timestamp?

I see _add_days, _add_months, and _add_years functions, but unfortunately no _add_minutes.

How do I accomplish this?

Best regards,

Andrew

0 votes

1 answer

3,690 views

0 votes

Accepted answer

Permanent link

Francesco Chiossi

(5.7k●1●11●19) Feb 05 '14, 9:30 a.m.

Hello Andrew,

you can try the solution in this technote:

How to Add Minutes to a Date-Time
http://www-01.ibm.com/support/docview.wss?uid=swg21422596

Best Regards,

Francesco Chiossi

Andrew Trobec selected this answer as the correct answer

1 vote

Comments

Andrew Trobec

Feb 05 '14, 9:37 a.m.

I knew there was a simple solution! Thank you so much!

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

usage

× 12,020

rational-insight

× 1,230

Question asked: Feb 05 '14, 9:25 a.m.

Question was seen: 3,690 times

Last updated: Feb 05 '14, 9:37 a.m.

In Rational Insight, how do I add hours to a timestamp?

Andrew Trobec

1 answer

3,690 views

0 votes

Accepted answer

Francesco Chiossi

Comments

Andrew Trobec

Your answer

Follow this question

Question details

Related questions