Re: Time - hundreds??

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/05/17
Message-ID: <Pine.SUN.3.91.960517084942.20539E-100000_at_seatimes>#1/1

On Fri, 17 May 1996, Barbara Hiles wrote:

> Does Oracle date/time include hundreds? I can get hh:mi:ss - we need the
> next lower level.

No. You have two choices.
1. Build a field to handle the hundreths portion as in HUNDRETHS NUMBER(2).

    You will need to capture this from someplace other than SYSDATE. 2. Build a field to handle the entire time in whatever format you wish to

    maintain. Put only the date information into the ORACLE DATE field type.

I'd prefer #1 myself.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Fri May 17 1996 - 00:00:00 CEST