--select * from prelancamentocontabil where convert(varchar, Data, 8) not like '00:00%'
--select * from Pagamento where substring(CONVERT(varchar, Data, 20), 12,5) != '00:00'
--select * from PreLancamentoContabil where substring(CONVERT(varchar, data, 20), 12,5) != '00:00'
--select * from PreLancamentoContabil inner join Pagamento on Pagamento.AutoID = PreLancamentoContabil.PagamentoOrigem where Pagamento.Data <> PreLancamentoContabil.Data

update PreLancamentoContabil set data = substring(CONVERT(varchar, data, 20), 1,10)+'  00:00:00.000' from PreLancamentoContabil    where substring(CONVERT(varchar, data, 20), 12,5) != '00:00' 
update lancamento set data = substring(CONVERT(varchar, data, 20), 1,10)+'  00:00:00.000' from lancamento    where substring(CONVERT(varchar, data, 20), 12,5) != '00:00' 
update pagamento set data = substring(CONVERT(varchar, data, 20), 1,10)+'  00:00:00.000' from pagamento    where substring(CONVERT(varchar, data, 20), 12,5) != '00:00'
update compromisso set dataprevisao = substring(CONVERT(varchar, dataprevisao, 20), 1,10)+'  00:00:00.000' from compromisso    where substring(CONVERT(varchar, dataprevisao, 20), 12,5) != '00:00' 
update compromisso set datavencimento = substring(CONVERT(varchar, datavencimento, 20), 1,10)+'  00:00:00.000' from compromisso    where substring(CONVERT(varchar, datavencimento, 20), 12,5) != '00:00' 
update documento set datarecebimentodocto = substring(CONVERT(varchar, datarecebimentodocto, 20), 1,10)+'  00:00:00.000' from documento    where substring(CONVERT(varchar, datarecebimentodocto, 20), 12,5) != '00:00' 
update documento set DataEmissao = substring(CONVERT(varchar, DataEmissao, 20), 1,10)+'  00:00:00.000' from documento    where substring(CONVERT(varchar, DataEmissao, 20), 12,5) != '00:00' 
update documentoBancos set datalancamento = substring(CONVERT(varchar, datalancamento, 20), 1,10)+'  00:00:00.000' from documento    where substring(CONVERT(varchar, datalancamento, 20), 12,5) != '00:00' 
update documentoBancos set data = substring(CONVERT(varchar, data, 20), 1,10)+'  00:00:00.000' from documento    where substring(CONVERT(varchar, data, 20), 12,5) != '00:00' 


--faturamento entrada

update notafiscalentrada set dataemissao = substring(CONVERT(varchar, 
dataemissao, 20), 1,10)+'  00:00:00.000' from notafiscalentrada    where 
substring(CONVERT(varchar, dataemissao, 20), 12,5) != '00:00'

update prelancamentocontabil set data =(
	select datarecebimento from notafiscalentrada where autoid = prelancamentocontabil.nfeorigem
)
where autoid in (
	select p.autoid
	from notafiscalentrada n
	inner join prelancamentocontabil p on p.nfeorigem=n.autoid
	where n.datarecebimento <> p.data
)


update PreLancamentoContabil set Data=SUBSTRING(convert(varchar, data, 120), 1, 10)
where convert(varchar, Data, 8) like '01:00%'

update PreLancamentoContabil set Data=DATEADD(hour, 1, data)
where convert(varchar, Data, 8) like '23:00%'

--contas a receber

update PreLancamentoContabil set PreLancamentoContabil.Data = DocumentosReceber.DataEmissao from 
DocumentosReceber inner join PreLancamentoContabil on PreLancamentoContabil.DocumentoReceberOrigem = DocumentosReceber.AutoId
where PreLancamentoContabil.Data <> DocumentosReceber.DataEmissao

--contas  a pagar
update pagamento set data = substring(CONVERT(varchar, data, 20), 1,10)+'  00:00:00.000' from pagamento    where substring(CONVERT(varchar, data, 20), 12,5) != '00:00'

update PreLancamentoContabil set data = substring(CONVERT(varchar, data, 20), 1,10)+'  00:00:00.000' from PreLancamentoContabil    where substring(CONVERT(varchar, data, 20), 12,5) != '00:00' 

update PreLancamentoContabil set PreLancamentoContabil.Data = Pagamento.Data from PreLancamentoContabil inner join Pagamento on Pagamento.AutoID = PreLancamentoContabil.PagamentoOrigem
where Pagamento.Data <> PreLancamentoContabil.Data