|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | udf_StringToDate |
| Schema | dbo |
| Function Type | Scalar |
| Deterministic | False |
| Is Encrypted | False |
| Ansi Nulls Status | True |
| Quoted Identifier Status | True |
| Description |
Parameters
| Name | Data Type | Direction | Description |
varchar(8) |
Input |
Parent Dependencies (objects that udf_StringToDate depends on)
| Name | Type |
StoredProcedure |
|
StoredProcedure |
Child Dependencies (objects that depend on udf_StringToDate)
| Name | Type |
Extended Properties
| Object | Property | Value |
DDL
|
/****** Object: UserDefinedFunction [dbo].[udf_StringToDate] Script Date: 03/09/2017 17:21:49 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE FUNCTION [dbo].[udf_StringToDate] ( @DateText VARCHAR(8) ) RETURNS datetime AS BEGIN DECLARE @TargetDateString VARCHAR(10) DECLARE @ConvertedDate datetime SET @TargetDateString = LEFT(@DateText,4) + '-' + SUBSTRING(@DateText,5,2) + '-' + RIGHT(@DateText,2) SET @ConvertedDate = cast(@TargetDateString AS DATETIME) RETURN @ConvertedDate END |
| Powered by BI Documenter |
