CREATE OR REPLACE PROCEDURE P_X_F( TEMP_ORGID number, BEGINDATE VARCHAR2, ENDDATE VARCHAR2, v_fsj OUT sys_refcursor)...
显示全部CREATE OR REPLACE PROCEDURE P_X_F(
TEMP_ORGID number,
BEGINDATE VARCHAR2,
ENDDATE VARCHAR2,
v_fsj OUT sys_refcursor)
时间参数,yqwcrq这个字段也是timestamp类型
rwyq.yqwcrq>=to_date(beginDate ||' 00:00:00','YYYY-MM-DD hh24:mi:ss')
收起