TO_CHAR:
number -> character
date -> character
TO_DATE:
character -> date
select * from logon_1;
select * from logon_1 where logon_date > to_date('JUL,10 2008', 'MON DD YYYY');
select to_char(logon_date,'MON DD YYYY') from logon_1;
select * from logon_1 where to_char(logon_date,'MON DD YYYY')='JAN 17 2012';