dUtcHalfHour

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

Attributes

Name Data Type Connects to:
utc_half_hour_key Edm.Int32
Key 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.
Table Attributes