Re: how to set seconds-precision for systimestamp

From: Ken Quirici <kquirici_at_yahoo.com>
Date: Sun, 19 Apr 2009 15:43:44 -0700 (PDT)
Message-ID: <3fd0892f-035f-487a-80e8-45d0e674f225_at_q16g2000yqg.googlegroups.com>

On Apr 19, 6:39 pm, Ken Quirici <kquir..._at_yahoo.com> wrote:
> On Oracle 10g (10.2) installed on my home PC with vista premium:
>
> I tried the following to have systimestamp return 9 digits of
> precision - it returns
> 9, but the last 6 are all always 0. How can I see those missing 6
> digits of precision?
> Thanks for any help.
>
> ken
>
> set serveroutput on size 1000000
>
> declare
>         currtimestamp   timestamp (9);
>         seconds         number(9);
>
> begin
>         currtimestamp := systimestamp;
>         dbms_output.put_line(to_char(currtimestamp,'ff9'));
>
> end;
> /

I of course mean digits of precision for the seconds. Received on Sun Apr 19 2009 - 17:43:44 CDT