Re: date, time format

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 17 May 1999 12:56:50 -0400
Message-ID: <7hpjdd$gge$1@autumn.news.rcn.net>

Hi Gennady,

Do nothing!

Oracle stores dates as 7-byte fields as follows:

        1st byte = Century
        2nd byte = Year
        3rd byte = Month
        4th byte = Day
        5th byte = Hour
        6th byte = Minute
        7th byte = Second

regards

Jerry Gitomer

Gennady wrote in message <373c9518$0$16644_at_fountain.mindlink.net>...
>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 Mon May 17 1999 - 11:56:50 CDT