Tired of all the typing required to specify a date in a query using TO_DATE?

SELECT SUM(sale_amt) AS december12_sales 
WHERE sale_date BETWEEN to_date('2012-12-01','YYYY-MM-DD') AND to_date('2012-01-01','YYYY-MM-DD');

Whew! Shake out your fingers, that was a pain. Fortunately, there’s an easier way. Read more