Re: EZ Oracle question...
From: Brett Neumeier <sacq_at_usa.net>
Date: 22 Jun 1999 23:43:51 GMT
Message-ID: <7kp73n$5bd$3_at_eve.enteract.com>
Date: 22 Jun 1999 23:43:51 GMT
Message-ID: <7kp73n$5bd$3_at_eve.enteract.com>
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'))
Well, I suspect that *April* 4th would need to be 04/04 ...
but to answer your question, you want the date format:
'MM/DD/YYYY/HH24/MI/SS'
-bn
sacq_at_usa.net
Received on Wed Jun 23 1999 - 01:43:51 CEST