Re: Default Date Format

In article <2ou4hp$ok1_at_cville-srv.wam.umd.edu>, dinguyen_at_wam.umd.edu (Dzi Nguyen) writes:
) Hello Netter,
) Does anyone know how to change the Oracle default date format without using
) to_date, maybe throught an environment variable or some sort?

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-Mon-YYYY HH24:MI:SS'

--Bill.

--
William R. Ward              Unix contractor               Apple PIE DTS
Work phone: 408/974-3668                         Voicemail: 408/479-4072
Work email: ward_at_newton.apple.com   Personal email: hermit_at_cats.ucsc.edu
Home email: hermit_at_bayview.com    (Finger hermit_at_ucscb.ucsc.edu for PGP)
------------------------------------------------------------------------
   Disclaimer: I do not speak for Apple Computer or anyone but myself