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!