Last Updated:
June 14, 2021
by
Jesse Langstaff
| Version: 10
| 2,462 views
| 0 followers
members are following updates on this item.
Provides a record of all half hour periods with corresponding time information in 11 time zones. A new row is added every half hour.
/odata/dUtcHalfHour
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. |