oracle8.1.6 select to_char(sysdate, 'YYYY-MM-DD') from dual posted_date = sysdate