Re: Date function

From: David A. Owens <daveo_at_criticaldata.com>
Date: 1998/04/01
Message-ID: <3522F0E8.1911@criticaldata.com>#1/1

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_at_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
Received on Wed Apr 01 1998 - 00:00:00 CST