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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Date/time question.

Re: Simple Date/time question.

From: Roeland Stouthart <oracle_at_worldonline.nl>
Date: 1997/03/19
Message-ID: <01bc33e6$98f4b580$dd141b91@oracle.kpmg.nl>#1/1 









Force12 Solutions Ltd <Force12_at_force12.com> wrote in article
<vBfzoAAn+WLzEwJv_at_force12.com>...


> I understand  you can have a combined date/time field in an Oracle

> table. Is this true? If so, what format should the values be entered in?

> I know the date goes in as '01-Jan-97'but I can't get a time to go in.




Try To_Date(DateVar, 'dd/mm/yyyy hh24:mi:ss") in your statements.



Roeland
Received on Wed Mar 19 1997 - 00:00:00 CST












Original text of this message













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