Hello, I am quite new to SQL and am having some problems. I have populated a table with info as well including the date and time... though when I go to search for the date and time... I only seem to be able to access the date! Can anyone point me in the right direction?

Below is what I have done:

I created table1 as such -

CREATE TABLE table1(
person INTEGER
,whn DATE
,code VARCHAR(10)
,PRIMARY KEY (person,whn)
);

And populated the table with -

INSERT INTO table1 VALUES (1,TO_DATE('25 Feb 2003 06:10:00','dd Mon YYYY HH24:MI:SS'),'XE 0A DB');

---- though when attempting -

SELECT whn FROM table1

I only get back the date ---- 25-FEB-03?!?

Thank you for any reply!

Regards,
Poot.