Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Timestamp precision on Windows 2k Server
Good morning,
do you store these values as well ..? We do have a lot of problem storing and reading timestamps from our Oracle 9 server. it looks like if all our problems are a result of the timestamp format but we do not find a valid time-format right now.
Any hints for us ..?!
Thanx a lot
Oliver
Scott Goldberg wrote:
> I am working on an application being developed against Oracle 9.2 on
> Windows 2k Server for deployment on Oracle 9.0.1 on Solaris and hit
> the following hiccup using timestamps.
>
> Under the windows environment, I never can get a timestamp with
> precision greater than 3. I.e:
> SELECT current_timestamp, current_timestamp(3)FROM dual
> always yields something like:
>
> CURRENT_TIMESTAMP
> -----------------------------------------
> CURRENT_TIMESTAMP(3)
> -----------------------------------------
> 17-JUL-02 12.00.44.392000 PM -04:00
> 17-JUL-02 12.00.44.392 PM -04:00
>
> Under solaris, I obtain the expected precisions:
> CURRENT_TIMESTAMP
> ---------------------------------------------------------------------------
> CURRENT_TIMESTAMP(3)
> ---------------------------------------------------------------------------
> 17-JUL-02 11.54.04.733216 AM -04:00
> 17-JUL-02 11.54.04.733 AM -04:00
>
> Is there some setting I can change to obtain the additional precisions
> under windows?
>
> Thanks
>
> Scott
Received on Mon Jul 29 2002 - 05:36:04 CDT