use EnVisage
update Scenario set StartDate = cast(StartDate as date), EndDate = cast(EndDate as date) where cast(StartDate as date) <> StartDate or cast(EndDate as date) <> EndDate