From: "David A. Owens" <daveo@criticaldata.com>
Subject: Re: Date function
Date: 1998/04/01
Message-ID: <3522F0E8.1911@criticaldata.com>#1/1
Content-Transfer-Encoding: 7bit
References: <3522D992.3AA137B6@ctp.com>
To: vragha@ctp.com
Content-Type: text/plain; charset=us-ascii
Organization: http://www.criticaldata.com
Mime-Version: 1.0
Reply-To: daveo@criticaldata.com
Newsgroups: comp.databases.oracle.server



Try doing this at the begining of the SQL*Plus session or put this in
your glogin.sql file:

alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS";


Vijay Raghavacharian wrote:
> 
> Guys!
> 
> I have a column in the table declared as DATE. When I do a select from
> the column, SQL*PLUS always returns the date component. I want to see
> the time component always along with the date component and I don't want
> to use the to_char() function. Can something be set in the environment.
> Needless to say the need is driven out of  laziness. I am using Oracle
> 7.3 on Oracle NT 4.0.
> 
> Thanks.
> 
> --
> Vijay Raghavacharian
> vragha@ctp.com
> voice: 650-372-6246
> fax: 650-372-6200
> 
> Cambridge Technology Partners (415-574-3710)
> 1300 South El Camino Real, Suite 600
> San Mateo, CA 94402
> http://www.ctp.com