• But this one is not working for SELECT CONVERT(CHAR(6), '2012-09-15', 112);

    i mean When we provide a hard coded date.