of******@hotmail.com wrote in message news:<56*************************@posting.google.c om>...
when i put record into table in this format
insert into test(boat_id,strartDate) values(2,to_date('2004-01-02
16:00:00','YYYY-MM-DD HH24:MI:SS'));
it is lood ok
but when i try to fet the record out
i see only the date and not the hour
how can i see the hour???/////
thanks Ofer
Sigh. Not enough information to answer your question.
What does your select look like?
What format do you get for the results of this query?
SELECT SYSDATE FROM DUAL;
Is the hour displayed?
Sorry we cannot be more helpful, but crystal balls are in short
supply, so they are restricted to the military. not that they ever
actually USE them 8^)
Ed