ViewReference_84

VMF_SurveyCellData

ViewReference_133

VMF_Booking

ViewReference_215

VMF_CardTransaction

VMD_Time

VMD_TIME

View

ViewsSurvey

VMD_Time

VMD_TIME

View

ViewsSurvey

ViewsSurveyDiagram

SELECT,VIEW DEFINITION

CardAccessReader

SELECT,VIEW DEFINITION

IssueTrackingReader

SELECT,VIEW DEFINITION

SurveyReader

MD_Time_TimeInteger

int

Integer representing the time of day in the format HHMMSS (e.g., 23:01:01 at one minute one second after eleven o'clock in the evening). Not typically used for reporting.

Unlike MD_Date_Dateinteger (in MD_Date), this integer is not really human-readable, because it's not set up for base-10. Rather, it's calculated using the formula: (hour << 16) Or (min << 8) Or (sec), where the Or's are logical, and the << operator is a binary left shift. In T-SQL, this is (hour * POWER(2, 16)) + (minute * POWER(2, 8)) + second.

MD_Time_HH24:MM

char(5)

Time of day in military/24-hour format (e.g., 13:00 = 1 pm). No seconds (or milliseconds). Padded with spaces on the left to five characters to faciliate sorting.

5

MD_Time_HH12:MM_AMPM

char(8)

Time of day in 12-hour am/pm format. Does not include seconds (e.g., 1:00 pm = thirteen hundred hours). Padded with spaces on the left to eight characters, to facilitate sorting.

8

MD_Time_HourOfDay12

int

Hour of day, by twelve-hour clock (0-11).

MD_Time_Second

int

Second of hour, 0 - 59.

MD_Time_ampm

char(2)

Value will be "am" or "pm" depending on whether the time in question occurs before or after 12:00 noon.

2