I have a Datetime field that I need to convert to just date. When I run the following query as a select, it works fine. As an update, nothing changes. Please let me know where I am going wrong as my brain is frozen.
update SITE set DATE = convert(varchar(10),DATE,101)
Thanks a lot.