Re: Date function

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: 1998/04/01
Message-ID: <3522E6D6.A004771D@access-laserpress.com>#1/1

The SELECT query is returning the entire column, but SQL*Plus by default only displays the date. You'll either have to use TO_CHAR with the proper format, or changes SQL*Plus' default format (which actually does the exact same thing).

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