----------------bussca por data no caso aqui data de emissão..------------------------------------
select autoid,DataEmissao,CONVERT(VARCHAR(10),DataEmissao,126)as data from DocumentosReceber
where CONVERT(VARCHAR(11),DataEmissao,114) >'00:00:00:00'

----------------------Update zerando------------------------------------------------------
update DocumentosReceber set DataQuitacao = CONVERT(VARCHAR(10),DataQuitacao,126)+' 00:00:00:00'
where CONVERT(VARCHAR(11),DataQuitacao,114) >'00:00:00:00'

update DocumentosReceber set DataVencimentoDocumento = CONVERT(VARCHAR(10),DataVencimentoDocumento,126)+' 00:00:00:00'
where CONVERT(VARCHAR(11),DataVencimentoDocumento,114) >'00:00:00:00'

update DocumentosReceber set DataEmissao = CONVERT(VARCHAR(10),DataEmissao,126)+' 00:00:00:00'
where CONVERT(VARCHAR(11),DataEmissao,114) >'00:00:00:00'