Example: Wrap around Midnight

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

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