As of Friday October 16th, access to restricted content on this site now requires you to log in with your Genesys account. If you don't have an account, you can request one at these locations: Request MyPartner Portal Account or Request My Support Account.
Jump to: navigation, search

EVENT_TIME Dimension

The EVENT_TIME dimension—like EVENT_DATE—is a static dimension that stores time information with minute-level granularity.

The EVENT_TIME Dimension
Field Data Type Description
EVENT_TIME_KEY int Primary key of this table.
EVENT_TIME_24 varchar(6) 24-hour time, stored in HHMM format—for example, “2301” (for 11:01 PM).
EVENT_TIME_12 varchar(8) 12-hour time, including AM or PM—for example, “1101PM”.
TIME_INTERVAL_15MIN int The 15-minute interval in which the time falls (1–96).
TIME_INTERVAL_30MIN int The 30-minute interval in which the time falls (1–48).
TIME_INTERVAL_60MIN int The 60-minute interval in which the time falls (1–24).
This page was last edited on February 24, 2015, at 17:50.

Feedback

Comment on this article:

blog comments powered by Disqus