Re: Problem with date

ofer_c33_at_hotmail.com wrote in message news:<5604e7df.0401020304.adf750f_at_posting.google.com>...
> 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 Received on Fri Jan 02 2004 - 10:12:50 CST