AnsweredAssumed Answered

Help to find date difference

Question asked by sure on Aug 2, 2016
Latest reply on Aug 11, 2016 by sure

Hi,

m curious to get date difference, in hours/minutes - not sure to deriving it. any help would be great.

 

select icl_usercookieid, count(1) cnt, max(icl_ets) max_time, min(icl_ets) min_time

,age(max(icl_ets),min(icl_ets)) age , cast(age(max(icl_ets),min(icl_ets))as INTERVAL day) aged

, cast(age(max(icl_ets),min(icl_ets))as INTERVAL minute) age

,cast(age(max(icl_ets),min(icl_ets))as INTERVAL hour) age

from `dfs`.`appdata`.`vw_ie_app_log`

 

 

output

 

 

 

 

Outcomes