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