select BoringColumn, to_char(DateTimeColumn, 'YYYYMMDD') as TheDate
from TABLE

##</code><code>##

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