Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | True |
| Execute As | |
| Null on Null Input | False |
| Schema Bound | False |
| Assembly |
Parameters
| Name | Data Type | Length | Description |
|---|---|---|---|
| (Result) | date | 3 | |
| @idate | varchar | 255 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE FUNCTION dbo.str_to_date (@idate varchar(255))
RETURNS date
WITH encryption ,
EXECUTE AS CALLER
AS
BEGIN
DECLARE @iOutput date
IF @idate is null or len(LTRIM(rtrim(@idate)))=0
SET @iOutput=null;
ELSE
BEGIN
SET @iOutput=convert( date , left(@idate,8),112 )
end
RETURN(@iOutput)
end;
GO
GO
CREATE FUNCTION dbo.str_to_date (@idate varchar(255))
RETURNS date
WITH encryption ,
EXECUTE AS CALLER
AS
BEGIN
DECLARE @iOutput date
IF @idate is null or len(LTRIM(rtrim(@idate)))=0
SET @iOutput=null;
ELSE
BEGIN
SET @iOutput=convert( date , left(@idate,8),112 )
end
RETURN(@iOutput)
end;
GO
Depends On
No items found
Used By
66- dbo.EXIM_DOC_IN_EXTRACT_DATA_BC_23_DEKSTOP
- dbo.EXIM_DOC_OUT_EXTRACT_DATA_BC30_DEKSTOP
- dbo.MG_MS_ADJUSTMENT_HEADER_ADD
- dbo.MG_MS_ADJUSTMENT_HEADER_EDIT
- dbo.MG_MS_BC_IN_ADD
- dbo.MG_MS_BC_IN_EDIT
- dbo.MG_MS_BC_IN_FINISH
- dbo.MG_MS_BC_IN_GET_KURS_INFO_NOW
- dbo.MG_MS_BC_IN_ITEM_ADD
- dbo.MG_MS_BC_IN_ITEM_DELETE
- dbo.MG_MS_BC_IN_ITEM_EDIT
- dbo.MG_MS_BC_OUT_EDIT
- dbo.MG_MS_BC_OUT_FINISH
- dbo.MG_MS_ITEM_FINAL_AVG_CREATE
- dbo.MG_MS_ITEM_FINAL_AVG_CREATE_BACKUP
- dbo.MG_MS_ITEM_FINAL_AVG_PABRIKASI_CREATE
- dbo.MG_MS_MEMO_HEADER_ADD
- dbo.MG_MS_MEMO_HEADER_EDIT
- dbo.MG_MS_MOLTS_GRN
- dbo.MG_MS_OUT_CAR_LINE_HEADER_ADD
- dbo.MG_MS_OUT_CAR_LINE_HEADER_EDIT
- dbo.MG_MS_OUT_CHANGE_PART_LIST_HEADER_ADD
- dbo.MG_MS_OUT_CHANGE_PART_LIST_HEADER_EDIT
- dbo.MG_MS_OUT_DISAMBLE_PART_LIST_HEADER_ADD
- dbo.MG_MS_OUT_DISAMBLE_PART_LIST_HEADER_EDIT
- dbo.MG_MS_OUT_PRODUCTION_PART_LIST_HEADER_ADD
- dbo.MG_MS_OUT_PRODUCTION_PART_LIST_HEADER_EDIT
- dbo.MG_MS_PRODUCTION_RETUR_HEADER_ADD
- dbo.MG_MS_PRODUCTION_RETUR_HEADER_EDIT
- dbo.MG_MS_STO_HEADER_ADD
- dbo.MG_MS_STO_HEADER_EDIT
- dbo.MG_MS_SUPPLIER_CUSTOMER_ADD
- dbo.MG_MS_SUPPLIER_CUSTOMER_EDIT
- dbo.MG_PEMI_RPT_261
- dbo.MG_PEMI_RPT_262
- dbo.MG_PEMI_RPT_BC23
- dbo.MG_PEMI_RPT_BC25
- dbo.MG_PEMI_RPT_BC27_IN
- dbo.MG_PEMI_RPT_BC27_OUT
- dbo.MG_PEMI_RPT_BC30
- dbo.MG_PEMI_RPT_BC40
- dbo.MG_PEMI_RPT_BC41
- dbo.MG_PEMI_RPT_DEVISA
- dbo.MG_PEMI_RPT_KB_DPIL
- dbo.MG_PEMI_RPT_KB_EKONOMI
- dbo.MG_PEMI_RPT_KB_EKSPOR
- dbo.MG_PEMI_RPT_KB_KB
- dbo.MG_PEMI_RPT_PENGANTAR
- dbo.MG_PEMI_RPT_REKAP
- dbo.MG_PEMI_RPT_RETURN
- dbo.MG_PEMI_RPT_rpMonthlyIncoming_BC23
- dbo.MG_PEMI_RPT_rpMonthlyOutgoing_BC30
- dbo.MS_MS_ITEM_FINAL_AVG_REPORT_ALL
- dbo.MS_MS_ITEM_FINAL_AVG_REPORT_ALL_BACKUP
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_IN
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_IN_AW_2340
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_IN_AW_2340_FIX
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_OUT
- dbo.RPT_DYNAMIC_MUTASI_BAHAN_BAKU
- dbo.RPT_DYNAMIC_MUTASI_BARANG_JADI
- dbo.RPT_DYNAMIC_MUTASI_MESIN
- dbo.RPT_DYNAMIC_MUTASI_MESIN_TEST
- dbo.RPT_DYNAMIC_MUTASI_SCRAP
- dbo.RPT_DYNAMIC_WIP
- dbo.sp_outgoing_production
- dbo.TEST_GRN_POST