ATK_USER_TIME_FREQ_HOUR_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ATK
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
USER_NAME FROM_USER_ACTIVITY_TIME TO_USER_ACTIVITY_TIME ACTIVITY_COUNT |
問合せ
| 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 |