query convert from oracle to mysql

[rohitpk]

Hello all,

can anyone conver the following ORACLE query to MySQl equivalent query,

$account_fields['avg_days_pay_c '] = $this->oracle("SELE CT ROUND(SUM(TO_DA TE(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('$smoag o 00:00:00','yyyy-mm�dd hh24:mi:ss')");


Thnx in advance.