how to set seconds-precision for systimestamp

From: Ken Quirici <kquirici_at_yahoo.com>
Date: Sun, 19 Apr 2009 15:39:39 -0700 (PDT)
Message-ID: <0644c076-f97c-4fdd-b10a-2199de7e9981_at_w40g2000yqd.googlegroups.com>

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;
/ Received on Sun Apr 19 2009 - 17:39:39 CDT