IF OBJECT_ID('[dbo].[DToTime]', 'FN') IS NOT NULL DROP FUNCTION [dbo].DToTime GO CREATE FUNCTION [dbo].[DToTime] ( @Date datetime ) RETURNS DATETIME AS BEGIN DECLARE @Result Datetime SELECT @Result = CONVERT(datetime,CONVERT(varchar(8),@Date,114)) RETURN @Result END GO