Re: Inserting a timestamp field

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 24 Jun 1999 13:20:07 -0700
Message-ID: <377292F7.EE1BC6BF@us.oracle.com>

Annette

The date field takes both date and time, but the time doesn't get measure to the millisecond level. The only thing I've seen do that is the get_time function (in DBMS_UTILITY?).

HTH. Pete

Annette Holt wrote:

> Hi,
>
> Has anyone had a need to insert a row in a table that capture a
> timestamp and date as one field? The date has to be included in the
> timestamp. If so, the timestamp need to display down to the
> milliseconds. Can Oracle8 handle it and what would be an appropriate
> format(s)?
>
> Please reply: annette.holt_at_lmco.com

Regards

Pete

Received on Thu Jun 24 1999 - 15:20:07 CDT