Re: Changing the default value for sysdate

From: Saar <sxmaxoz_at_us.oracle.com>
Date: Wed, 05 Aug 1998 12:35:19 -0700
Message-ID: <35C8B3F6.1251B062@us.oracle.com>

Steve Raftery wrote:

> Thanks in advance.
>
> In my database I would like to change the system date for one of my
> users who is telneting in from a different time zone.
> Is there a way to alter a users schema so that it displays Eastern Time
> instead of Pacific time (which is the default for the rest of the users)
>

for that single user that telnets in set TZ before logging into Oracle:

setenv TZ GMT+4

--

 __  _    _  __    _ _   _   _ ___  ______________________________
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Compaq SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Wed Aug 05 1998 - 14:35:19 CDT