Hi
Im trying to remove the “time” from a datetime field in a Table on SQL sever 2000
Im using this from today
(convert(datetime,floor(convert(float(24),getdate()))))
which is working for any records added to the Database from today
anyone got any tips for removing the time from records already in the Database, keeping the original Date?
Thanks