Re: Time - hundreds??

In article <BEH.395.0007E0FE_at_csd.uwm.edu>, BEH_at_csd.uwm.edu (Barbara Hiles) writes:
|> Does Oracle date/time include hundreds? I can get hh:mi:ss - we need the
|> next lower level.
|> TIA - Barb.

The DATE datatype does not store hundreds of a second - seconds are the lowest granualurity. I would recommend using another datatype, such as VARCHAR2 (or a combination). You could do something like

DATE (up to seconds) + NUMBER (hundreds) or one VARCHAR2 in some format like HH24:MI:SS:<hundreds>

-- 
------------------------------------------------------------------------
Scott Urman            Oracle Corporation           surman_at_us.oracle.com
------------------------------------------------------------------------
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2
Published by Oracle Press - http://www.osborne.com/oracle/index.htm
------------------------------------------------------------------------
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"
------------------------------------------------------------------------