Re: Cant see the time

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 23 Oct 2001 11:26:20 +0200
Message-ID: <ttajhimffr4572@corp.supernews.com>

"Andy" <alarkin77_at_excite.co.uk> wrote in message news:a608f020.0110230057.7756f648_at_posting.google.com...
> Hi,
>
> this is probbably a silly questions but when inserting a timestamp
> into my oracle DB i cannot see the time!!
>
> Example:
>
> INSERT INTO table_name values(sysdate);
>
> SELECT * FROM table_name;
>
> column_name (columns_name is type DATE)
> -----------
> 23-OCT-01
>
> I would expect to see '23-OCT-01 09:09:09'. Is the time just not
> displayed or is the time not being inserted into the DB?
>
> Thanks in advance.
> Andy.

The default NLS_DATE_FORMAT is DD-MON-YY You need to use an appropiate call to to_char with an appropiate format mask like 'dd-mon-rr hh24:mi:ss' Time to visit the sql reference manual.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 23 2001 - 04:26:20 CDT