Re: Problem with date

ofer_c33_at_hotmail.com wrote:
>
> 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

Why not use a mask, just like you used to put the value in?

If you read the manuals, you will find this is the default behaviour for date columns. Received on Fri Jan 02 2004 - 11:53:27 CST