Re: Simple Date/time question.

In article <vBfzoAAn+WLzEwJv_at_force12.com>, Force12 Solutions Ltd <Force12_at_force12.com> wrote:

> 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.
>

Hadi,

The time is part of the date datatype. Formatting options are numerous, and include: HH, HH12, HH24, MI, SS, SSSS, AM or PM, A.M. or P.M., and, you can include plain text in your formatting.

Sources for all the formats include the online Docs, The Complete Oracle Reference, Oracle PL/SQL Programming by Feuerstein to name a few.

Cheers,

gary         -=- visit The C Programmers' Reference -=-
          http://users.southeast.net/~garyg/C_ref/C/c.html
               The AVENUE Programmers' Class Requests
             http://users.southeast.net/~garyg/class.htm