format(update_datetime , 'yyyy/MM/dd') => convert datetime field to 1234/56/78 format convert(nvarchar(10), getdate() , 111) -> 1234/56/78 select convert(nvarchar(10), getdate() , 8) -> time 12:33:45