Re: milli seconds
From: Mark Malakanov <markmal_at_home.com>
Date: Thu, 19 Apr 2001 17:24:32 GMT
Message-ID: <kbFD6.52860$5E3.16536893_at_news3.rdc1.on.home.com>
Date: Thu, 19 Apr 2001 17:24:32 GMT
Message-ID: <kbFD6.52860$5E3.16536893_at_news3.rdc1.on.home.com>
You can not get milliseconds from Oracle. Only hundreds of seconds. See v$timer view.
You cannot store fractions of seconds in DATE columns. Store this in NUMBER columns.
-- ----------------------------------------------------- Thanks, Mark "Bigfoot" <ext6axp_at_ups.com> ???????/???????? ? ???????? ?????????: news:9bn02c$h863_at_biko.telecom.ups.com...Received on Thu Apr 19 2001 - 19:24:32 CEST
> Is there a way to store milli or micro seconds in Oracle tables.
> Is there a date format in Oracle which allow to retrieve milli or
> micro seconds?
>
> Thanks
> Pushparaj
>