It's all about the answers!

Ask a question

Converting timestamp to integer?


Sarah Byrum (214) | asked Jul 28 '16, 11:43 a.m.
edited Jul 29 '16, 9:18 a.m.
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!

Be the first one to answer this question!


Register or to post your answer.