Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> date, time format
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. Received on Fri May 14 1999 - 16:32:09 CDT