You simply use something like this:

UPDATE tbldummy SET datefield = CONVERT(VARCHAR(8), GETDATE(), 112)

Works great

If you can do a select query, but you want drop the time you can use:

select CONVERT(VARCHAR(10),...