SELECT COUNT(CONTRACTS.CONTRACTDATE) as TOTAL
FROM CONTRACTS, MEDIA
WHERE
    TO_CHAR(TO_DATE('24-1-2013','DD-MM-YYYY'), 'YYYY-MM-DD') = TO_CHAR(TO_DATE(substr(CONTRACTDATE, 0, 19),'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD')
  AND
    MEDIA.INFLUENCE = 'p'
  AND
    MEDIA.KIND = 'tv';