select BoringColumn, convert(varchar(8),DateTimeColumn,112) as TheDate
from TABLE