Maintenance Notice - PDF Generation
Dynamic PDF generation for web-based content is temporarily unavailable. This maintenance affects dynamic PDF files that are generated from either the HTML-based page or manual that you are viewing. Links that normally allow this functionality have been hidden, and will reappear as soon as the feature is restored.

Note: Access to static files, including PDF files that are not dynamically generated from our web-based content, is unaffected.

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 August 19, 2014, at 16:04.


Comment on this article:

blog comments powered by Disqus