Re: Date function

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/02
Message-ID: <6fuu1f$85e@bgtnsc03.worldnet.att.net>#1/1

On Wed, 01 Apr 1998 16:19:31 -0800, Vijay Raghavacharian <vragha_at_ctp.com> wrote:

>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.

Try this:

SQL> ALTER SESSION SET NLS_DATE_FORMAT = "DD-MON-YYYY HH:MI:SS"
2 ;

Session altered.

SQL> SELECT SYSDATE FROM DUAL; SYSDATE

01-APR-1998 09:43:41 Received on Thu Apr 02 1998 - 00:00:00 CST