Of what, the DATUM variable? If so then input() is the one you want:
proc sql;
create table QUERY as
select input(DATUM,yymmdd10.) as DATE,
MENGE
from DEMAND.DMAND
order by DATE;
quit;
You cannot change the type of a variable, you need to create a new variable - which is what the select as is actually doing behind the scene.