Re: ?Setting System Date Format

In article <36gfv0$gpd_at_babyblue.cs.yale.edu>,

        keith_at_moe (Keith Hilgeman) writes:
> Got a question. We want to change the format for the default date field
> format from dd-mon-yy to dd-mon-yyyy (the year 2000 is sure going to be fun).
> Also, so that indexing on date will pick this up. Is this a configurable
> parameter?

Yes; in your initsid.ora file (or whatever your system calls it), include the line

nls_date_format = "DD-MON-YYYY"

then shutdown and startup the instance.
(I'm assuming you're running Oracle version 7)

> Keith Hilgeman
> Computer Science Corp
> Heidelberg, Germany
> hilgeman_at_heidelberg-emh2.army.mil

Hank Robinson
Oracle DBA
University of Warwick Received on Sat Oct 01 1994 - 13:49:08 CET