Remove Time from DateTime Field

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

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

:slight_smile:

Perfect just what I was looking for

Thanks R937