Re: Problem with date
From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 02 Jan 2004 17:53:27 GMT
Message-ID: <3FF5AFA9.2EF05C7B_at_yahoo.net>
Date: Fri, 02 Jan 2004 17:53:27 GMT
Message-ID: <3FF5AFA9.2EF05C7B_at_yahoo.net>
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 - 18:53:27 CET