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!
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!