Re: EZ Oracle question...

On Mon, 21 Jun 1999 16:07:36 -0400, "Robert J. McCready" <rmccread_at_mitre.org> wrote:

>Hello all,
>
>This has to be one of the easiest questions I have ever posted, but I'm
>stuck. I have a DATE Field in my table. I want to enter the date April
>4th, 1999 00:06:08
>
>I've tried this SQL command with Oracle:
>
>INSERT INTO MAPPER_ENTRIES
> (ENTRY_ID, EMP_NUM, URL_ID, DATE_VIEWED)
>VALUES
> (1, 16708, 1, TO_DATE('01/04/1999/00/06/08',
>'MM/DD/YYYY/HH/MI/SS'))
>
>
>Would anybody know how to tell Oracle that I'm recording the date on a
>24 hour clock and not a 12 hour clock. If so, would you know what the
>correct SQL would be?

... to_date ('04/04/1999/00/06/08', 'MM/DD/YYYY/HH24/MI/SS')...

              ^^                                ^^^^
              April                             24-hour