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

/* Insert December 5, 2000 */
SET DateStyle TO 'US';
INSERT INTO test003 VALUES('12/5/2000');

/* Insert May 12, 2000 */
SET DateStyle TO 'European';
INSERT INTO test003 VALUES('12/5/2000');