dbo.ufnGetAccountingEndDate
Documentation | AdventureWorks |
Schema | dbo |
Name | ufnGetAccountingEndDate |
Module | Sales |
Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
Input/Output
Mode | Name | Data type | Description | |
---|---|---|---|---|
1 | OUT | Returns | datetime |
Used by
Name |
---|
dbo.ufnGetAccountingEndDate
|
Script
CREATE FUNCTION [ufnGetAccountingEndDate]() RETURNS [datetime] AS BEGIN RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112)); END; |
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56