Database Reference
In-Depth Information
-- Listing 3.1
SELECT DateKey, FullDateAlternateKey,
CONVERT(varchar, FullDateAlternateKey,
101) AS DateName, DayNumberOfWeek,
EnglishDayNameOfWeek,
SpanishDayNameOfWeek,
FrenchDayNameOfWeek, DayNumberOfMonth,
DayNumberOfYear, WeekNumberOfYear,
EnglishMonthName,
SpanishMonthName, FrenchMonthName,
MonthNumberOfYear, CalendarQuarter, 'Q' +
CAST(CalendarQuarter AS varchar)
+ ' ' + CAST(CalendarYear AS varchar)
AS FullCalendarQuarter, CalendarYear,
CalendarSemester, FiscalQuarter,
FiscalYear, FiscalSemester
FROM DimDate
Search WWH ::
Custom Search