-
Notifications
You must be signed in to change notification settings - Fork 23
/
Dim_Date.sql
24 lines (24 loc) · 725 Bytes
/
Dim_Date.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- Cleansed Dim_Date_Table --
SELECT
[DateKey],
[FullDateAlternateKey] AS Date,
--,[DayNumberOfWeek],
[EnglishDayNameOfWeek] AS Day,
--,[SpanishDayNameOfWeek]
--,[FrenchDayNameOfWeek]
--,[DayNumberOfMonth]
--,[DayNumberOfYear]
[WeekNumberOfYear] AS WeekNumber,
[EnglishMonthName] AS Month,
LEFT([EnglishMonthName], 3) AS MonthShort, -- Take 3 characters from the left side of [EnglishMonthName]
--,[SpanishMonthName]
--,[FrenchMonthName]
[MonthNumberOfYear] AS MonthNumber,
[CalendarQuarter] AS Quater,
[CalendarYear] AS Year --,[CalendarSemester]
--,[FiscalQuarter]
--,[FiscalYear]
--,[FiscalSemester]
FROM
[AdventureWorksDW2019].[dbo].[DimDate]
WHERE CalendarYear >= 2019;