Function: [AdventureWorks2016CTP3].[dbo].[ufnGetAccountingEndDate]

CollapseAll image

Collapse image Function properties


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

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 Objects that depend on [dbo].[ufnGetAccountingEndDate]


Object name Object type Dep level
[Sales].[uSalesOrderHeader] Trigger 1
Total 1 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Scalar function used in the uSalesOrderHeader trigger to set the starting account date.

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;
GO
EXEC sp_addextendedproperty N'MS_Description', N'Scalar function used in the uSalesOrderHeader trigger to set the starting account date.', 'SCHEMA', N'dbo', 'FUNCTION', N'ufnGetAccountingEndDate', NULL, NULL
GO

Collapse image See also


List of functions