Re: EZ Oracle question...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 21 Jun 1999 22:10:51 +0800
Message-ID: <376E47EB.6624@yahoo.com>

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/

Use HH24 not HH

select to_char(sysdate,'HH24') from dual;

13
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Jun 21 1999 - 09:10:51 CDT