Re: date, time format

From: <shiling_at_math.wayne.edu>
Date: Sat, 15 May 1999 01:53:45 GMT
Message-ID: <7hik39$4pb$1@nnrp1.deja.com>

My version 7 book says no. I'm not sure if it has changed in version 8.

In a query,

TO_CHAR(date_value, datetime_format)

In article <373c9518$0$16644_at_fountain.mindlink.net>, "Gennady" <gennadyb_at_halcosoftware.com> wrote:
> Hello,
> I use Personal Oracle 8 and I have a table
> with date type column. When I open this table in
> Oracle8 Navigator window I can see only
> DD-MON-YY part of the column
> even after I altered session like:
> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI:SS';
> After that NLS_SESSION _PARAMETERS contains NLS_DATE_FORMAT =
'DD-MON-YY
> HH24:MI:SS',
> but NLS_DATABASE_PARAMETERS contains NLS_DATE_FORMAT = 'DD-MON-YY '.
> How can I get the date in the table (not in a query!) in DD-MON-YY
> HH24:MI:SS format?
>
> Gennady.
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 14 1999 - 20:53:45 CDT