Example: Wrap around Midnight - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

When creating period events, use the Wrap around midnight option to have a time frame spanning midnight.

If the From time of a period event is later than the To time, two time segments are available: midnight until the To time and the From time until midnight. When Wrap around midnight is not selected, the period event is in effect for segment 1 and segment 2 on each specified day. When Wrap around midnight is selected, the event is in effect for segment 2 on each specified day and for segment 1 on each day following the specified day.

For example, specify that a period event occurs on Mondays and Tuesdays with a From time of 17:00 and a To time of 08:00.
If Wrap around midnight is not selected:
  Monday Tuesday Wednesday
Midnight—08:00 (time segment 1) Yes Yes No
08:00—17:00 No No No
17:00—23:59 (time segment 2) Yes Yes No
If Wrap around midnight is selected:
  Monday Tuesday Wednesday
Midnight—08:00 (time segment 1) No Yes Yes
08:00—17:00 No No No
17:00—23:59 (time segment 2) Yes Yes No