Re: Cant see the time

From: Bliss <bliss_is_ignorance_at_hotmail.com>
Date: Tue, 23 Oct 2001 17:41:27 +0800
Message-ID: <3bd53b3c_1@news.tm.net.my>

Andy,

You cannot see the time by selecting the date field... You'll have to explicitly give the command to see the time...

select to_char (date_column_name, 'DD-MON-YYYY HH:MI:SS') from table name;

Hope this helps....

Regards,
Bliss

"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.
Received on Tue Oct 23 2001 - 04:41:27 CDT