100th of seconds

100th of seconds

Post by Sbai » Sun, 31 Dec 1899 09:00:00

Hi everyone,
I know that exist an Oracle package that give me the hundredth of seconds,
but I can't remember the name of the package and the name of the procedure.
Can anyone help me to remeber this procedure?

Thanks a lot


100th of seconds

Post by Bernard Delmé » Sun, 31 Dec 1899 09:00:00

try either dbms_utility.get_time() or 'select hsecs from v$timer;'


1. Always Rounding UP on 100th's Position

I must always rould up in the 100th's position.

EXAMPLE:    10.131 should become 10.14
                       10.139 should become 10.14
                       10.140 should become 10.14
                       10.130 should become 10.13

What is needed is the Ceiling function at the decimal level!

Any ideas for a slick way in an SQL statement?



2. Monterrey, Mexico - Oracle DBA

3. Select * but beetwen the 100th and 200th element

4. Cursor and textpointer problem

5. SQL Server 2000 Agent dies

6. Q: How to select 20th to 100th rows?

7. Database expanding

8. Changing format from seconds to hours:minutes:seconds

9. Converting Varchar Seconds to Minutes:Seconds Format

10. Converting seconds to hour:minutes:seconds

11. Second CFP: ADVIS2002 - Second Biennial International Conference on Advances in Information Systems