How to find TimeStamp difference in App Dynamics Query Language (ADQL)?
I tried column1 - column2. Getting error message "Operator [SUBTRACTION] not valid on field types [DATETIME], [DATETIME].
Asked
Active
Viewed 243 times
1
-
well i might be mistaken but its worth a try, DATEDIFF(column1,column2) ? not sure but I remember it beeing based on oracles sql spec it might work – subkonstrukt Apr 21 '17 at 10:06
-
Already i tried this approach. DATADIFF is a unknown function in AppDynamic query language. – user2867900 Apr 21 '17 at 10:14
-
okay sorry for that, as said it was a rather wild guess – subkonstrukt Apr 21 '17 at 10:21