select case when CAST((cast (@date as nvarchar) + ' ' + (select cast(convert(time(7),'2021-08-07 09:00:00.000') as nvarchar))) AS DATE) <GETUTCDATE() then 1 else 0 end
Try the above Code. It Works. You have to convert varchar to date field again to compare with another date field.