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) | varchar | 255 | |
| @idate | datetime | 8 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE FUNCTION dbo.date_to_str (@idate datetime )
RETURNS varchar(255)
WITH encryption ,
EXECUTE AS CALLER
AS
BEGIN
DECLARE @iOutput varchar(255)
IF @idate is null
SET @iOutput=''--convert(varchar(255), convert(datetime,'') ,103) + ' ' + convert(varchar(255), convert(datetime,'') ,108)
ELSE
SET @iOutput= convert(varchar(255),@idate ,103)
RETURN(@iOutput)
end;
GO
GO
CREATE FUNCTION dbo.date_to_str (@idate datetime )
RETURNS varchar(255)
WITH encryption ,
EXECUTE AS CALLER
AS
BEGIN
DECLARE @iOutput varchar(255)
IF @idate is null
SET @iOutput=''--convert(varchar(255), convert(datetime,'') ,103) + ' ' + convert(varchar(255), convert(datetime,'') ,108)
ELSE
SET @iOutput= convert(varchar(255),@idate ,103)
RETURN(@iOutput)
end;
GO
Depends On
No items found
Used By
69- dbo.vw_ms_manual_invoce
- dbo.vw_ms_memo_header
- dbo.vw_ms_molts_grn
- dbo.vw_ms_molts_invoce
- dbo.MG_MS_ADJUSTMENT_HEADER_ADD
- dbo.MG_MS_ADJUSTMENT_HEADER_APPROVE
- dbo.MG_MS_ADJUSTMENT_HEADER_CANCEL
- dbo.MG_MS_ADJUSTMENT_HEADER_EDIT
- dbo.MG_MS_BC_IN_ADD
- dbo.MG_MS_BC_IN_CANCEL
- 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_IMPORT_FROM_CEISA
- dbo.MG_MS_BC_IN_IMPORT_FROM_GRN
- dbo.MG_MS_BC_IN_IMPORT_FROM_INVOICE
- dbo.MG_MS_BC_IN_IMPORT_FROM_MOLTS
- dbo.MG_MS_BC_OUT_CANCEL
- dbo.MG_MS_BC_OUT_EDIT
- dbo.MG_MS_BC_OUT_FINISH
- dbo.MG_MS_BC_OUT_IMPORT_FROM_MEMO
- dbo.MG_MS_CAR_LINE_DELETE
- dbo.MG_MS_CHECK_BUSINESS_DATE_AND_AVG
- dbo.MG_MS_GRN_MAP_SUPPLIER_MANUAL
- dbo.MG_MS_ITEM_DELETE
- 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_MANUAL_INVOICE_FILE_DELETE
- dbo.MG_MS_MANUAL_INVOICE_FILE_PROSSES
- dbo.MG_MS_MANUAL_INVOICE_MAP_SUPPLIER_MANUAL
- dbo.MG_MS_MEMO_DETAIL_ADD
- dbo.MG_MS_MEMO_DETAIL_EDIT
- dbo.MG_MS_MEMO_HEADER_ADD
- dbo.MG_MS_MEMO_HEADER_APPROVE
- dbo.MG_MS_MEMO_HEADER_CANCEL
- dbo.MG_MS_MEMO_HEADER_EDIT
- dbo.MG_MS_MOLTS_FILE_DELETE
- dbo.MG_MS_MOLTS_FILE_PROSSES
- dbo.MG_MS_MOLTS_GRN_row_detail
- dbo.MG_MS_MOLTS_INVOICE_MAP_SUPPLIER_MANUAL
- dbo.MG_MS_OUT_CAR_LINE_DETAIL_ADD
- dbo.MG_MS_OUT_CAR_LINE_DETAIL_EDIT
- dbo.MG_MS_OUT_CAR_LINE_HEADER_ADD
- dbo.MG_MS_OUT_CAR_LINE_HEADER_APPROVE
- dbo.MG_MS_OUT_CAR_LINE_HEADER_AUTO_SUPPLY
- dbo.MG_MS_OUT_CAR_LINE_HEADER_CANCEL
- 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_PRODUCTION_PART_LIST_HEADER_ADD
- dbo.MG_MS_OUT_PRODUCTION_PART_LIST_HEADER_CANCEL
- dbo.MG_MS_OUT_PRODUCTION_PART_LIST_HEADER_EDIT
- dbo.MG_MS_PRODUCTION_RETUR_DETAIL_ADD
- dbo.MG_MS_PRODUCTION_RETUR_DETAIL_DELETE
- dbo.MG_MS_PRODUCTION_RETUR_DETAIL_EDIT
- dbo.MG_MS_PRODUCTION_RETUR_HEADER_ADD
- dbo.MG_MS_PRODUCTION_RETUR_HEADER_APPROVE
- dbo.MG_MS_PRODUCTION_RETUR_HEADER_CANCEL
- dbo.MG_MS_PRODUCTION_RETUR_HEADER_EDIT
- dbo.MG_MS_STO_HEADER_ADD
- dbo.MG_MS_STO_HEADER_APPROVE
- dbo.MG_MS_STO_HEADER_CANCEL
- dbo.MG_MS_STO_HEADER_EDIT
- dbo.RPT_DYNAMIC_MUTASI_BAHAN_BAKU
- dbo.RPT_DYNAMIC_MUTASI_BARANG_JADI
- dbo.RPT_DYNAMIC_MUTASI_MESIN
- dbo.RPT_DYNAMIC_MUTASI_SCRAP