EZ Oracle question...
From: Robert J. McCready <rmccread_at_mitre.org>
Date: Mon, 21 Jun 1999 16:07:14 -0400
Message-ID: <376E9B72.F82F85FF_at_mitre.org>
[Quoted] Hello all,
Date: Mon, 21 Jun 1999 16:07:14 -0400
Message-ID: <376E9B72.F82F85FF_at_mitre.org>
[Quoted] Hello all,
[Quoted] 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:07:14 CEST