回答:CONCATENATE("BGYP", format(today(),"yyyyMMdd"), sql("finereport", "SELECT lpad(NVL(max(substr(id,13,4))+1,1),4,0) FROM BGYP_BPM", 1, 1))
回答:where ${" b.signature_date >= to_date('"+FORMAT(startdate,'yyyy-MM')+"-1 00:00:00','yyyy-mm-dd hh24:mi:ss' ) and b.signature_date <= to_date(to_char(to_date('"+startdate+"','yyyy-mm-dd'),'yyyy-mm-dd')||' 23:59:59','yyyy-mm-dd hh24:mi:ss' )"}
2
2
21
10
没有更多