7/21/2019 Guia Para Obtener Las Fechas de Events

1/1

selectEvents.EventId,Events.EventName,Events.TimeFrame,CASE Events.TimeFramewhen 'D' then CONVERT(varchar(20), Events.StartDate,101)when 'M' then DATENAME(month, Events.StartDate) + ', '+ CONVERT(VARCHAR(6), Events.YearQuarter)----when 'M' then (select right(convert(varchar, Events.StartDate, 106), 8) )else ''end as Fechafrom dbo.Events Events