Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Converting timestamp to integer?

Hi,

I have a piece of data that is in the form of a timestamp, and need to do a calculation with it. I need to determine the number of days between the two timestamp dates, and convert that to an integer to be used in the rest of the calculation. Is there a method to strip out the date portion and convert the difference between two dates to an integer?

I am using the advanced sql query in JRS.

Thank you in advance!

0 votes


Be the first one to answer this question!

Register or log in to post 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.

Search context
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
× 37

Question asked: Jul 28 '16, 11:43 a.m.

Question was seen: 2,500 times

Last updated: Jul 29 '16, 9:18 a.m.

Confirmation Cancel Confirm