Hello all,

Can any one convert the following query from ORACLE into MySQL format.

$account_fields['avg_days_pay_c'] = $this->oracle("SELECT ROUND(SUM(TO_DATE(PAID_DATE) - TO_DATE(INVOICE_DATE))/COUNT(*)) AS AVGDAYS
FROM INVO
WHERE BILLTO_ABRV = '$focus->kp_code_c'
AND IS_PAID = 'Y'
AND STATUS <> 'Void'
AND PAID_DATE > to_date('$smoago 00:00:00','yyyy-mm\Uffffffffdd hh24:mi:ss')");

Thnx a lot in advance.