How to convert following mysql query to oracle?
I found the query:

SELECT TO_CHAR(to_date('1970-01-01 00','yyyy-mm-dd hh24:mi') +(ceil( TIME/ (20160  * 1000)) * 20160 )/60/60/24 , 'yyyy-mm-dd HH24:MI') "Time",
  SUM(CreatedInstanceCount)     AS "CreatedInstanceCount",
  SUM(InitializedInstanceCount) AS "InitializedInstanceCount",
  SUM(ActiveInstanceCount)      AS "ActiveInstanceCount",
  SUM(TerminatedInstanceCount)  AS "TerminatedInstanceCount"
FROM MEMBER_COUNT
WHERE ApplicationId='wso2is-500-application'
AND to_date('1970-01-01 00','yyyy-mm-dd HH24:MI')              +(ceil( TIME/ (20160  * 1000)) * 20160 )/60/60/24 BETWEEN sysdate-7 AND SYSDATE
GROUP BY TO_CHAR(to_date('1970-01-01 00','yyyy-mm-dd hh24:mi') +(ceil( TIME/ (20160  * 1000)) * 20160 )/60/60/24 , 'yyyy-mm-dd HH24:MI'),
  ApplicationId
ORDER BY TO_CHAR(to_date('1970-01-01 00','yyyy-mm-dd hh24:mi') +(ceil( TIME/ (20160  * 1000)) * 20160 )/60/60/24 , 'yyyy-mm-dd HH24:MI') ;