Re: Time in Milli seconds

From: <G.Plivna_at_itsystems.lv>
Date: Tue, 5 Sep 2000 09:17:23 +0300
Message-Id: <10610.116183@fatcity.com>

Hi!

FUNCTION dbms_utility.get_time RETURNS NUMBER

returns the number of 100ths of seconds

Used only to calculate the time between two events, not to get absolut current time

Gints Plivna

                                                                                                                   
                    prem_at_ibsplc.c                                                                                  
                    om                   To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    Sent by:             cc:                                                                       
                    root_at_fatcity.        Subject:     Time in Milli seconds                                        
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    00.09.05                                                                                       
                    10:35                                                                                          
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   




Hi group,
     Can anybody tell me how to get the time in milli seconds using an Sql

statement.

Regs
Prem

--
Author:
  INET: prem_at_ibsplc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Sep 05 2000 - 01:17:23 CDT