0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

-- What data dump is SEDE using?

declare @last date = (select max(CreationDate) from posts);
select year(@last) [Year], case month(@last)
  when 1 then 'January'
  when 2 then 'February'
  when 3 then 'March'
  when 4 then 'April'
  when 5 then 'May'
  when 6 then 'June'
  when 7 then 'July'
  when 8 then 'August'
  when 9 then 'September'
  when 10 then 'October'
  when 11 then 'November'
  when 12 then 'December'
  end [Month];

view current version

edited oct 29 10

created oct 29 10 Roger Pate