/* Create a table we can experiment with */
CREATE TABLE
   test002 (my_date DATE);

/* Date formats from:
 * http://msdn.microsoft.com/library/books/devintl/S25C7.HTM
 */

/* Insert a date using the Czech/Czech Republic format */
INSERT INTO test002 VALUES( TO_DATE('27.10.1994', 'DD.MM.YY') );

/* Insert a date using the Albanian/Albania format */
INSERT INTO test002 VALUES( TO_DATE('1994-06-29', 'YY-MM-DD') );

/* Select the dates we just inserted */
SELECT TO_CHAR(my_date, 'MONTH DD, YYYY') AS MY_DATE
  FROM test002;