Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Problem with date

Problem with date

From: <ofer_c33_at_hotmail.com>
Date: 2 Jan 2004 03:04:55 -0800
Message-ID: <5604e7df.0401020304.adf750f@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 Received on Fri Jan 02 2004 - 05:04:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US