select TO_DATE(sysdate, 'dd/mm/yyyy') from dual
select TO_CHAR(sysdate, 'MM/DD/YYYY') from dual;
select sysdate from dual;
select * from myTable where DTTMCREATED BETWEEN TO_DATE('09/20/2012','mm/dd/yyyy') AND TO_DATE('09/21/2012','mm/dd/yyyy')
/* as it's case insensitive in sql, so MM==mm
Oracle use mi to replace mm, and hh24 to represent use 24 hours format. */
Oracle date related SQL queries
