dUtcHalfHour

Wiki HomeTitle Index

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

NameData TypeConnects to:
utc_half_hour_keyEdm.Int32

Attributes

NameData TypeConnects to:
utc_dtEdm.DateTimeOffsetUTC date time in the format mm/dd/yyyy HH:MM:SS.
utc_day_keyEdm.Int32Day of the current half hour period in UTC time. Day 1 corresponds to January 1, 2004.
us_eastern_dtEdm.DateTimeOffsetEastern date time in the format mm/dd/yyyy HH:MM:SS.
us_eastern_half_hour_keyEdm.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_keyEdm.Int32 Day of the current half hour period in Eastern time. Day 1 corresponds to January 1, 2004.
us_central_dtEdm.DateTimeOffsetCentral date time in the format mm/dd/yyyy HH:MM:SS.
us_central_half_hour_keyEdm.Int32Central time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
us_central_day_keyEdm.Int32Day of the current half hour period in Central time. Day 1 corresponds to January 1, 2004.
us_mountain_dtEdm.DateTimeOffsetMountain date time in the format mm/dd/yyyy HH:MM:SS.
us_mountain_half_hour_keyEdm.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_keyEdm.Int32Day of the current half hour period in Mountain time. Day 1 corresponds to January 1, 2004.
us_pacific_dtEdm.DateTimeOffset Pacific date time in the format mm/dd/yyyy HH:MM:SS.
us_pacific_half_hour_keyEdm.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_keyEdm.Int32Day of the current half hour period in Pacific time. Day 1 corresponds to January 1, 2004.
arabia_st_dtEdm.DateTimeOffsetArabia date time in the format mm/dd/yyyy HH:MM:SS.
arabia_st_half_hour_keyEdm.Int32Arabia time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
arabia_st_day_keyEdm.Int32Day of the current half hour period in Arabia time. Day 1 corresponds to January 1, 2004.
uk_dtEdm.DateTimeOffsetUnited Kingdom date time in the format mm/dd/yyyy HH:MM:SS.
uk_half_hour_keyEdm.Int32United Kingdom time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
uk_day_keyEdm.Int32Day of the current half hour period in United Kingdom time. Day 1 corresponds to January 1, 2004.
eu_central_dtEdm.DateTimeOffsetCentral European date time in the format mm/dd/yyyy HH:MM:SS.
eu_central_half_hour_keyEdm.Int32Central European time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
eu_central_day_keyEdm.Int32Day of the current half hour period in Central European time. Day 1 corresponds to January 1, 2004.
eu_eastern_dtEdm.DateTimeOffsetEastern European date time in the format mm/dd/yyyy HH:MM:SS.
eu_eastern_half_hour_keyEdm.Int32Eastern European time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
eu_eastern_day_keyEdm.Int32Day of the current half hour period in Eastern European time. Day 1 corresponds to January 1, 2004.
bz_dtEdm.DateTimeOffsetBrazil date time in the format mm/dd/yyyy HH:MM:SS.
bz_half_hour_keyEdm.Int32Brazil time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
bz_day_keyEdm.Int32Day of the current half hour period in Brazil time. Day 1 corresponds to January 1, 2004.
nt_dtEdm.DateTimeOffsetNewfoundland date time in the format mm/dd/yyyy HH:MM:SS.
nt_half_hour_keyEdm.Int32Newfoundland time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
nt_day_keyEdm.Int32Day of the current half hour period in Newfoundland time. Day 1 corresponds to January 1, 2004.
atl_dtEdm.DateTimeOffset Atlantic date time in the format mm/dd/yyyy HH:MM:SS.
atl_half_hour_keyEdm.Int32Atlantic time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
atl_day_keyEdm.Int32Day of the current half hour period in Atlantic time. Day 1 corresponds to January 1, 2004.


0 Comments

Sorry, comments are closed.
  • 1,969 views
  • 0 previews
  • 10 versions
  • 0 comments
  • 1 follower
     
    1 subscriber is following updates on this item.
Avg. Rating:
Updated By:
Jesse Langstaff
 
June 14, 2021
Posted By:
Jesse Langstaff
 
April 20, 2018
Versions:
v.10
Search this area
Viewed 1,969 times