convert varchar

select top 10 datediff(day,skontodatum3,getdate()) as "Tage",convert(varchar(14),vorgangsdatum,1) as "Vorgangsdatum",convert(varchar(14),skontodatum3,1) as "Fälligkeitsdatum",convert(varchar(10),buchdatum,1)as "Buchdatum" from auftrag   

where buchdatum > '01.01.2022'   

===============================

SELECT * FROM zeitmessung  

where (CONVERT( varchar( 10 ), [update], 112 ) like '%20220626%' and art = '1002')                                                

or (CONVERT( varchar( 10 ), [update], 112 ) like '%20220626%' and art = '1003')   

================================