/ Published in: SQL
Expand |
Embed | Plain Text
/****** Object: UserDefinedFunction [dbo].[fnDateFromDateTime] Script Date: 11/26/2007 09:09:00 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[fnDateFromDateTime]') AND xtype IN (N'FN', N'IF', N'TF')) DROP FUNCTION [dbo].[fnDateFromDateTime] -- Gets the date part of a datetime input CREATE FUNCTION dbo.fnDateFromDateTime ( @DateTime datetime ) RETURNS datetime AS BEGIN RETURN (CONVERT(datetime, CONVERT(varchar(10), @DateTime, 101))) END
You need to login to post a comment.
