Oracle timestamps below seconds granularity

We are trying to display the hundredths of a second value stored in timestamps for certain records, but we are unable to find a format model that will allow us to achieve this level of granularity. Ideally, we want to see the entire date/time stamp in a format like this:

        02 FEB 1998 06:25:37.07 where the .07 is the hundredths of a second value in the timestamp. We've checked the SQL and PL/SQL manuals and several third party texts and are unable to find any information on this. It appears that Oracle can store the timestamp with this granularity but cannot display the partial seconds via any documented method.

This is a third-party application that we own and are trying to query based on the timestamp. Altering the application is an undesirable option at best.

It's difficult to believe that no one has ever done anything like this before, especially in scientific applications.

Responses via e-mail (jonathan.w.ingram_at_tek.com) and via newsgroup are welcome. Thanks much for your help in advance.

Jonathan Ingram
Tektronix, Inc. Database Administrator Received on Thu Feb 19 1998 - 00:00:00 CET