
/*------ ATD 315256 ------*/
-- Comandos para acertar data de cancelamento gravada com horas
update nfsaidacad set dtcancel = CONVERT(DATETIME, CONVERT(CHAR(10), dtcancel, 103), 103) 
where dtcancel > CONVERT(DATETIME, '07/02/2017', 103)
go
update nfentracad set dtcancel = CONVERT(DATETIME, CONVERT(CHAR(10), dtcancel, 103), 103) 
where dtcancel > CONVERT(DATETIME, '07/02/2017', 103)
go