SELECT DATENAME(m,'1995-01-28 12:15:32.123')
, DATENAME(m,'1995-02-28 12:15:32.123')
, DATENAME(m,'1995-03-28 12:15:32.123')
, DATENAME(m,'1995-04-28 12:15:32.123')
, DATENAME(m,'1995-05-28 12:15:32.123')
, DATENAME(m,'1995-06-28 12:15:32.123')
, DATENAME(m,'1995-07-28 12:15:32.123')
, DATENAME(m,'1995-08-28 12:15:32.123')
, DATENAME(m,'1995-09-28 12:15:32.123')
, DATENAME(m,'1995-10-28 12:15:32.123')
, DATENAME(m,'1995-11-28 12:15:32.123')
, DATENAME(m,'1995-12-28 12:15:32.123');
Under an English environment, the above...