TO_DATE()函数

  

4月份已确认了合同的代理费收入

输出字段：

结算客户编号/结算客户名称/（合同的）订单币种/订单金额/代理费

 

Eapt_ftcontractheader 合同表

Eapt_customer 客户表

 

 

 

select c.customercode,c.customernamecn,fh.pocurrency,fh.totalpoamount,fh5.paymentofagent

 

from eapt_ftcontractheader fh,eapt_ftcontractheader5 fh5,eapt_customer c

where fh.paymentcustomer = c.customerno

      and fh.ftcontractno = fh5.ftcontractno

      and fh.ftcstatus<>'NEW'

     -- and fh.totalpoamount>0

      and fh.customdate >= TO_DATE('2007-4-1','YYYY-MM-DD')

 and fh.customdate <= TO_DATE('2007-4-30','YYYY-MM-DD')