Cant see the time

From: Andy <alarkin77_at_excite.co.uk>
Date: 23 Oct 2001 01:57:21 -0700
Message-ID: <a608f020.0110230057.7756f648@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 - 03:57:21 CDT