LISTING 1: Code to Create the PhoneSystemDate Scalar UDF
CREATE FUNCTION dbo.PhoneSystemDate
( @SecondsIn int )
RETURNS datetime
AS
BEGIN
   RETURN (SELECT DATEADD(ss, @SecondsIn, 'Jan 1, 1970'))
END
GO