not sure why I am stuck but can someone tell me ho...
# generalm
Mark Needham
10/16/2019, 11:18 PMnot sure why I am stuck but can someone tell me how to calculate the number of hours between two date/time fields? in a saved search using date/time1-date/time2 does not seem to give me hours
b
battk
10/16/2019, 11:28 PMare they date columns or datetime columns
m
Mark Needham
10/16/2019, 11:33 PMdatetime
Mark Needham
10/16/2019, 11:33 PMits datetime1-datetime2 age in hours
b
battk
10/16/2019, 11:42 PMalthough it looks ridiculous, convert the timestamps to dates
battk
10/16/2019, 11:43 PM Copy code
TO_DATE(TO_CHAR({datetime1}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') - TO_DATE(TO_CHAR({datetime2}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS')battk
10/16/2019, 11:43 PMwill give you difference in days
m
Mark Needham
10/16/2019, 11:45 PMthanks I will give this a shot
b
battk
10/17/2019, 12:13 AMi personally hope someone has a better solution
k
KevinJ of Kansas
10/17/2019, 12:14 AMI've always been able to just subtract them and divide by 24
KevinJ of Kansas
10/17/2019, 12:15 AMNow, often times I have to do an additional thing to break it up into two columns, one for days and one for hours
KevinJ of Kansas
10/17/2019, 12:15 AMSo that it was readable