Re: Simple Date/time question.

From: Joe Brouillette <76433.1232_at_compuserve.com>
Date: 1997/03/19
Message-ID: <01bc346a$5359c0e0$57efaec7@joey>#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.
>
> Thanks in advance
>
> Hadi
> --
> Force12 Solutions Ltd
>

use insert into table (date_column) values (to_date '19970101 13:01:01' 'YYYYMMDD HH24:MI:SS'); Just lookup the to_date, to_char functions. Received on Wed Mar 19 1997 - 00:00:00 CST