Re: TOAD questions (date format / file association)

From: Jim Lyons <jlyons4435_at_my-deja.com>
Date: Fri, 18 Aug 2000 14:11:52 GMT
Message-ID: <8njg6p$s00$1@nnrp1.deja.com>

In article <8nic50$kkd$1_at_nnrp1.deja.com>, Susie Grace <hlng_at_usa.net> wrote:

> I want to have dates displayed / handled in standard
> Oracle format (e.g. 16-AUG-2000).

If you mean you want to change the default way in which dates are displayed, you can insert a line like the following in the init.ora file:

nls_date_format = "<desired date format>"

--
Jim Lyons                     |  Network Systems Analyst
Entertech - The IC2 Institute |  512-482-0273, ext. 269
University of Texas at Austin |  jlyons_at_weblyons.com
http://www.weblyons.com


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Aug 18 2000 - 09:11:52 CDT