SQL Server versions prior to 2008 did not provide Date and Time data types.
Below is a solution for SQL Server 2005 and 2000 that will strip time off a DateTime data type value.
SELECT DATEADD(DAY,DATEDIFF(DAY,0,[DateTime]),0)
Example Use
-- Create a variable of type DATETIME and store a date and time it it.
DECLARE @DateWithTime DATETIME
DECLARE @DateWithoutTime DATETIME
-- Store a date with time in the @DateWithTime variable.
SET @DateWithTime = GETDATE()
-- See date and time:
SELECT @DateWithTime
-- Use the solution to store only the date in the @DateWithoutTime variable.
SET @DateWithoutTime = DATEADD(DAY,DATEDIFF(DAY,0,@DateWithTime),0)
-- See date without time:
SELECT @DateWithoutTime