Re: Does Oracle support miliseconds?

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Tue, 30 Mar 1999 08:59:49 +0000
Message-ID: <37008474.40CFDD98@capgemini.co.uk>

I believe the answers are no.can't and no.

I think there is a supplied package that will return the time accurate to milliseconds but this cannot be stored 'as is' in a date field without losing the fractions.

I believe the date/time datatypes are somewhat lacking when compared to other RDBMS date/time datatypes. Does anyone know if 8i offers any improvements?

EBR wrote:

> Hi,
>
> Maybe this is a very basic question, but I'm coming from MS-SQL Server
> and trying to migrate an application. The question is very simple:
>
> - Does Oracle Date type support milisseconds? If so, how to display
> milisseconds? I searched in NLS_DATE_FORMAT and found nothing about
> milisseconds.
>
> - Does SYSDATE return miliseconds?
>
> Thank you very much,
>
> Eugenio Reis
> ** Please remove the prime numbers to get my real e-mail
Received on Tue Mar 30 1999 - 02:59:49 CST