Re: Date Format

From: Prakash V <venkatprakash_at_hotmail.com>
Date: Tue, 31 Aug 1999 02:20:24 GMT
Message-ID: <19990831022025.91740.qmail@hotmail.com>

Hi:

Also I think u need to change the NLS_DATE_FORMAT parameter in init<dbs>.ora file also and shutdown & up the database. Otherwise use alter session N_DATE_FORMAT facility, if need be.

THanks

>
>Hi.
>
> Try using NLS_DATE_FORMAT parameter of init.ora.
>
> Good luck. Michael.
>
>In article <7qerqf$b2r$1_at_nnrp1.deja.com>,
> charles_lin_at_computerhorizons.com wrote:
> > Is any body know how to set date format in database to 4 digit year
> > expression(dd-mmm-yy to dd-mmm-yyyy).
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
>
>
>
> _____________________________________________________________
> Deja.com: Share what you know. Learn what you don't.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C7qeshu%24bit%241%40nnrp1.deja.com%3E
>

---

Get Your Private, Free Email at http://www.hotmail.com

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Mon Aug 30 1999 - 21:20:24 CDT