I know this information is found in thousands of other places on the Internet, but I decided to post a simple way to format dates in SQL here since I can never seem to remember. And now I can just look at my own blog instead of searching the web.
To format the dates returned from a query:
select TO_CHAR(birth_date, 'YYYY/MM/DD'), TO_CHAR(hire_date, 'YYYY/MM/DD') from EMPLOYEE;
To format dates in a WHERE clause:
select * from EMPLOYEE where hire_date > TO_DATE('2010-12-18','YYYY-MM-DD');
Hopefully by writing it down, now I will remember.