v_DIM_TIME

Contains times

Fields

Field	Field Type	Null	Description
TIMEDIMID	int		BBDW.[DIM_TIME].[TIMEDIMID]
TIME	time	yes	BBDW.[DIM_TIME].[TIME]
TIMESTRING	nchar	yes	BBDW.[DIM_TIME].[TIMESTRING]
HOUR	tinyint	yes	BBDW.[DIM_TIME].[HOUR]
HOURSTRING	nchar	yes	BBDW.[DIM_TIME].[HOURSTRING]
MINUTE	tinyint	yes	BBDW.[DIM_TIME].[MINUTE]
MINUTESTRING	char(2)	yes	BBDW.[DIM_TIME].[MINUTESTRING]
MILITARYHOUR	tinyint	yes	BBDW.[DIM_TIME].[MILITARYHOUR]
MILITARYHOURSTRING	nchar	yes	BBDW.[DIM_TIME].[MILITARYHOURSTRING]
AMPM	nchar	yes	BBDW.[DIM_TIME].[AMPM]
AMPMCODE	bit	yes	BBDW.[DIM_TIME].[AMPMCODE]
STANDARDTIME	nchar	yes	BBDW.[DIM_TIME].[STANDARDTIME]
MILITARYTIME	nchar	yes	BBDW.[DIM_TIME].[MILITARYTIME]

Definition

Copy


create view [BBDW].[v_DIM_TIME] as 
  select 
    [TIMEDIMID],
    [TIME],
    [TIMESTRING],
    [HOUR],
    [HOURSTRING],
    [MINUTE],
    [MINUTESTRING],
    [MILITARYHOUR],
    [MILITARYHOURSTRING],
    [AMPM],
    [AMPMCODE],
    [STANDARDTIME],
    [MILITARYTIME]
  from [BBDW].[DIM_TIME];