Microsoft SQL Server, 57 Bytes
SELECT UPPER(FORMAT(CAST('201601'+'01' AS DATE),'MMMyy'))
The Upper
function is required as format does not produce Upper case months as would be expected with the MMM format pattern.
Usage:
drop table t;
create table t (n VARCHAR(6));
insert into t values ('201604');
insert into t values ('200001');
insert into t values ('000112');
insert into t values ('123405');
SELECT UPPER(FORMAT(CAST(n+'01' AS DATE),'MMMyy')) FROM t