IF EXISTS (select name, * from sysobjects where name = 'fod_YMD2Datetime' and Type = 'FN') Drop function fod_YMD2Datetime GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION fod_YMD2Datetime(@Year int, @Month int, @Day int) RETURNS datetime AS -- ============================================= -- Author: FOd -- Create date: <2009-01-30> -- Description: Aus Jahr, Monat und Tag ein Datetime liefern -- ============================================= BEGIN DECLARE @d datetime; SET @d = dateadd(year,(@Year - 1753),'1/1/1753'); SET @d = dateadd(month,@Month - 1,@d); SET @d = dateadd(day, @Day - 1, @d); RETURN @d END go --Select dbo.gc_YMD2Datetime(2009, 1, 30)