NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Functions > dbo.TryParseDateIntTimeInt

Dependencies for SQL scalar function: Util.dbo.TryParseDateIntTimeInt

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.TryParseDateIntTimeInt	SQL scalar function	Util.dbo.TryParseDateTime	Assembly (CLR) scalar-function	1	[Util].[dbo].[TryParseDateTime]
Util.dbo.TryParseDateTime	Assembly (CLR) scalar-function	Util.UtilClr	ASSEMBLY	2	[Util].[dbo].[TryParseDateTime], [Util].[UtilClr]

SQL scalar function: Util.dbo.TryParseDateIntTimeInt

CREATE FUNCTION dbo.TryParseDateIntTimeInt (@DateInt INT,
                                            @TimeInt INT)
RETURNS DATETIME
AS
BEGIN
    RETURN
    (SELECT Util.dbo.[TryParseDateTime](LEFT(dtPart, 4) + '-' + SUBSTRING(DtPart, 5, 2) + '-' + SUBSTRING(DtPart, 7, 2) + ' ' + LEFT(TimePart, 2) + ':'
                                        + SUBSTRING(TimePart, 3, 2) + ':' + SUBSTRING(TimePart, 5, 2) + '.' + SUBSTRING(TimePart, 7, 3))
     FROM   (SELECT CAST( @DateInt AS VARCHAR) AS DtPart, LEFT (CAST( @TimeInt AS VARCHAR) + '00000000', 9) AS TimePart) a)
END

Description for SQL scalar function: Util.dbo.TryParseDateIntTimeInt

Todo