Re: Time - hundreds??

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

Have a look at the V$TIMER virual table as I believe that it gives 100ths of seconds.

If you need it just to separate transactions in your database then consider using a SEQUENCE rather than a clock tick as you will have to code around daylight saving times etc.

Bruce...

--
  -----------------
   T T T T T T T T        Bruce Pihlamae
   I I I I I I I I        bpihlama_at_nla.gov.au
   I I I I I I I I        National Library of Australia
   T T T T T T T T        Phone: +616 262-1575
  -----------------       Fax:   +616 273-2116
 ===================
 "If you swallow a live frog first thing in the morning;
  nothing worse will happen to either of you that day."