Chat2DB
Chat2DB copied to clipboard
CodePhiliaX
Optimization: EXTRACT function display
There seems to be no problem with my testing here. Can you provide your table structure
here is it. CREATE TABLE t_wms_outstock_doc ( receive_doc character varying(50) null, finish_time timestamp without time zone null, doc_no character varying(50) null, doc_type character varying(50) null, dispatch_sn character varying(50) null, doc_status character varying(255) null, outstock_date timestamp without time zone null, light_flag character varying(10) DEFAULT 'N'::character varying null, data_auth_out character varying(33) null, id character varying(40) not null, dept_id character varying(40) null, create_user character varying(40) null, create_time timestamp without time zone null, edit_user character varying(40) null, edit_time timestamp without time zone null, data_auth character varying(40) null, plan_outstock_date timestamp without time zone null, close_emp character varying(33) null, close_reason character varying(500) null, is_urgent character varying(1) null, is_upload_erp character varying(1) null, memo character varying(500) null, close_time timestamp without time zone null, area_sn character varying(20) null, doc_source character varying(1) null, is_release character varying(1) null, pick_doc_type character varying(255) null, pick_doc_attr character varying(255) null, supplier_id character varying(255) null, cust_id character varying(255) null, data_version numeric DEFAULT '0'::numeric null, cost_center character varying(40) null, expense_type character varying(100) null, ascription_type character varying(100) null, interior_orders character varying(40) null, sap_doc_no character varying(50) null, data_sources character varying(10) null, connect_no character varying(255) null, process_order_id character varying(40) null, upload_erp_status character varying(2) null, del_flag character varying(5) null, cost_item_text character varying(4) null, project_base_id character varying(40) null, use_dept character varying(50) null, sap_create_user character varying(50) null, sap_create_time timestamp without time zone null, duty_user character varying(40) null, duty_dept character varying(40) null, other_outstock_item character varying(50) null, internal_transfer_order character varying(255) null, wbs_id character varying(40) null, CONSTRAINT t_wms_outstock_doc_pkey PRIMARY KEY (id) );