SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION FLTIMETODATE (@FLTIME float) RETURNS datetime AS BEGIN DECLARE @FLTIMETODATE datetime SET @FLTIMETODATE = CAST(CONVERT(varchar, DATEADD(s, @FLTIME, '1980'), 101) AS DATETIME) RETURN(@FLTIMETODATE) END GO