Remove Time from DateTime Field


Im trying to remove the “time” from a datetime field in a Table on SQL sever 2000

Im using this from today

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?


UPDATE daTable
   SET datetimecolumn = CONVERT(DATETIME,FLOOR(CONVERT(FLOAT(24),datetimecolumn)))


Perfect just what I was looking for

Thanks R937