Re: EZ Oracle question...

Use HH24 instead of HH.

Robert J. McCready 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?
>
> Thank you all again
>
> --
> Robert J. McCready Knowledge Management Software Engineer
> Email: rmccread_at_mitre.org The MITRE Corporation
> Phone: (781)-271-2288 202 Burlington Rd MS:K308
> Fax: (781)-271-2352 Bedford, MA 01730
> Web Site: http://www.mitre.org/resources/centers/it/g062/kmsystems/
Received on Mon Jun 21 1999 - 22:20:47 CEST