Datetime type is accurate to hours, minutes and seconds, how to remove minutes and seconds

lj0917

select getdate ()

select convert (char (10), getdate (), 120)