ATK_TIME_FREQ_HOUR_V

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name
USER_NAME FROM_USER_ACTIVITY_TIME TO_USER_ACTIVITY_TIME ACTIVITY_COUNT

Query

SQL_Statement

select user_name, timestamp '2000-01-01 00:00:00.00' - numtodsinterval( trunc( ( extract(day from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*86400+ extract(hour from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*3600+ extract(minute from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*60+ extract(second from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second) )/(3600) )*(3600), 'SECOND' ) from_user_activity_time, timestamp '2000-01-01 00:00:00.00' - numtodsinterval( trunc( ( extract(day from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*86400+ extract(hour from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*3600+ extract(minute from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*60+ extract(second from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second) )/(3600)-1 )*(3600), 'SECOND' ) - interval '0.000001' second to_user_activity_time , count(*) activity_count from atk_usage_logs_v group by user_name, timestamp '2000-01-01 00:00:00.00' - numtodsinterval( trunc( ( extract(day from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*86400+ extract(hour from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*3600+ extract(minute from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*60+ extract(second from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second) )/(3600) )*(3600), 'SECOND' ), timestamp '2000-01-01 00:00:00.00' - numtodsinterval( trunc( ( extract(day from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*86400+ extract(hour from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*3600+ extract(minute from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second)*60+ extract(second from (timestamp '2000-01-01 00:00:00.00' - user_activity_time) day(9) to second) )/(3600)-1 )*(3600), 'SECOND' ) - interval '0.000001' second