Re: Can Oracle 7.x store 4-digit year dates?

From: Marc Scheuner <marc.scheuner_at_NO.SPAM.PLEASE.ch>
Date: 1997/08/08
Message-ID: <33eb38ef.33234158@news.bernoise.ch>#1/1

Erwan Layman <erwan_at_contact.com.sg> wrote:
>I am new to Oracle and I'm wondering if i can extend the year part of a
>DATE data type into 4 digits, ie, DD-MMM-YYYY. I want to avoid revamping
>my tables when year 2000 comes.

Oracle always stores dates internally as numerical values, if you only see two digits for the year, that's simply a setting of preference for your session.

Check out the ALTER SESSION SET NLS_DATE_FORMAT command. You can set any kind of date display you would like to have with it.

HTH
Marc

---

[ Marc Scheuner, marc.scheuner_at_berner.ch CH-3001 BERNE, Switzerland ]

---

Received on Fri Aug 08 1997 - 00:00:00 CDT