Help for this page

Select Code to Download

Select or download this

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

Select or download this

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