Function: [AdventureWorks2016CTP3].[dbo].[ufnGetAccountingEndDate_native]

CollapseAll image

Collapse image Function properties


 Name   Value 
 Schema   [dbo] 
 Owner   [dbo] 
 Creation date   23.10.2015 
 Type   Scalar 
 Is schema bound 
 Is deterministic   
 Encrypted   
 Implementation type   Transact SQL 
 ID   1652200936 

Collapse image Creation options


Name Value
QUOTED_IDENTIFIER ON
ANSI_NULLS ON

Collapse image Recordset returned


Name  Datatype  Max length 
@Return datetime 8

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION dbo.ufnGetAccountingEndDate_native()
RETURNS [datetime] 
WITH NATIVE_COMPILATION, SCHEMABINDING
AS 
BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL=SNAPSHOT, LANGUAGE=N'us_english')

    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20160701', 112));

END
GO

Collapse image See also


List of functions