Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> EZ Oracle question...
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 01730Web Site: http://www.mitre.org/resources/centers/it/g062/kmsystems/ Received on Mon Jun 21 1999 - 15:07:36 CDT