Transformar datas em sql

select * from prre where convert(varchar(8),dtref,112)>='20130930'