Last Updated:
June 14, 2021
by
Jesse Langstaff
| Version: 10
| 2,847 views
| 0 followers
members are following updates on this item.
dUtcHalfHour
Description
Provides a record of all half hour periods with corresponding time information in 11 time zones. A new row is added every half hour.
URL
/odata/dUtcHalfHour
Keys
Attributes
| Name | Data Type | Connects to: |
|---|---|---|
| utc_dt | Edm.DateTimeOffset | UTC date time in the format mm/dd/yyyy HH:MM:SS. |
| utc_day_key | Edm.Int32 | Day of the current half hour period in UTC time. Day 1 corresponds to January 1, 2004. |
| us_eastern_dt | Edm.DateTimeOffset | Eastern date time in the format mm/dd/yyyy HH:MM:SS. |
| us_eastern_half_hour_key | Edm.Int32 | Eastern time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| us_eastern_day_key | Edm.Int32 | Day of the current half hour period in Eastern time. Day 1 corresponds to January 1, 2004. |
| us_central_dt | Edm.DateTimeOffset | Central date time in the format mm/dd/yyyy HH:MM:SS. |
| us_central_half_hour_key | Edm.Int32 | Central time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| us_central_day_key | Edm.Int32 | Day of the current half hour period in Central time. Day 1 corresponds to January 1, 2004. |
| us_mountain_dt | Edm.DateTimeOffset | Mountain date time in the format mm/dd/yyyy HH:MM:SS. |
| us_mountain_half_hour_key | Edm.Int32 | Mountain time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| us_mountain_day_key | Edm.Int32 | Day of the current half hour period in Mountain time. Day 1 corresponds to January 1, 2004. |
| us_pacific_dt | Edm.DateTimeOffset | Pacific date time in the format mm/dd/yyyy HH:MM:SS. |
| us_pacific_half_hour_key | Edm.Int32 | Pacific time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| us_pacific_day_key | Edm.Int32 | Day of the current half hour period in Pacific time. Day 1 corresponds to January 1, 2004. |
| arabia_st_dt | Edm.DateTimeOffset | Arabia date time in the format mm/dd/yyyy HH:MM:SS. |
| arabia_st_half_hour_key | Edm.Int32 | Arabia time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| arabia_st_day_key | Edm.Int32 | Day of the current half hour period in Arabia time. Day 1 corresponds to January 1, 2004. |
| uk_dt | Edm.DateTimeOffset | United Kingdom date time in the format mm/dd/yyyy HH:MM:SS. |
| uk_half_hour_key | Edm.Int32 | United Kingdom time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| uk_day_key | Edm.Int32 | Day of the current half hour period in United Kingdom time. Day 1 corresponds to January 1, 2004. |
| eu_central_dt | Edm.DateTimeOffset | Central European date time in the format mm/dd/yyyy HH:MM:SS. |
| eu_central_half_hour_key | Edm.Int32 | Central European time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| eu_central_day_key | Edm.Int32 | Day of the current half hour period in Central European time. Day 1 corresponds to January 1, 2004. |
| eu_eastern_dt | Edm.DateTimeOffset | Eastern European date time in the format mm/dd/yyyy HH:MM:SS. |
| eu_eastern_half_hour_key | Edm.Int32 | Eastern European time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| eu_eastern_day_key | Edm.Int32 | Day of the current half hour period in Eastern European time. Day 1 corresponds to January 1, 2004. |
| bz_dt | Edm.DateTimeOffset | Brazil date time in the format mm/dd/yyyy HH:MM:SS. |
| bz_half_hour_key | Edm.Int32 | Brazil time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| bz_day_key | Edm.Int32 | Day of the current half hour period in Brazil time. Day 1 corresponds to January 1, 2004. |
| nt_dt | Edm.DateTimeOffset | Newfoundland date time in the format mm/dd/yyyy HH:MM:SS. |
| nt_half_hour_key | Edm.Int32 | Newfoundland time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| nt_day_key | Edm.Int32 | Day of the current half hour period in Newfoundland time. Day 1 corresponds to January 1, 2004. |
| atl_dt | Edm.DateTimeOffset | Atlantic date time in the format mm/dd/yyyy HH:MM:SS. |
| atl_half_hour_key | Edm.Int32 | Atlantic time half hour value. Starts at 1 on January 1, 2004 at 12AM and increments by 1 every half hour. |
| atl_day_key | Edm.Int32 | Day of the current half hour period in Atlantic time. Day 1 corresponds to January 1, 2004. |
Viewed 2,847 times