Contains 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
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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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 12 AM 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. |