When I try to use current timestamp value in an insert statement in a trigger the value returned only uses the first 3 values in the microsecond section of the timestamp, i.e. 2009-05-04 12:35:01.859000. The remaining 3 positions always display zeros. How do I get values in the final three positions?

We are using db2 v 9.1.200.98 on a Windows server.

Thanks

I thought that it was came from Windows OS.
Here is a discussion giving hints (some may be annoying, because of narrow-mindedness of a person who stick to his(/her?) own mind).
comp.databases.ibm-db2 | Google Groups

DB2 gets it from the OS, and that is all that Windows provides.