clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3798924 fiddles created (41832 in the last week).

CREATE FUNCTION dbo.Repro (@myYear int) RETURNS datetime AS BEGIN IF @myYear <> 1990 BEGIN RETURN NULL END DECLARE @firstOfYear datetime; SET @firstOfYear = DATEFROMPARTS(@myYear, 1, 1); IF DATEDIFF(day, @firstOfYear, @firstOfYear) <> 0 BEGIN RETURN NULL END RETURN @firstOfYear END
 hidden batch(es)


SELECT dbo.Repro(0)
Msg 289 Level 16 State 1 Line 1 Cannot construct data type date, some of the arguments have values which are not valid.
 hidden batch(es)