Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle date

Re: oracle date

From: Peter Valicek <Sonny2_at_gmx.net>
Date: Sun, 06 Apr 2003 11:22:36 +0200
Message-ID: <pan.2003.04.06.09.22.35.926321@gmx.net>


On Fri, 04 Apr 2003 08:49:28 +0000, Daniel Roy wrote:

> If you're on 9i, read about the new datatypes "timestamp with time
> zone" and "timestamp with local time zone", that might be what you
> need.

No currently still on 8.1.7 which won't be change in the future.

> Note that the default display format of such fields is decided
> with the parameter nls_timestamp_format, which can be altered at the
> session level.

Is this an parameter which can be set as well in the env of the proper user?

-Peter

-- 
[_Linux is like a wigwam,
	no windows,no gates - apache inside_]
Received on Sun Apr 06 2003 - 04:22:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US