DB2 Version 9.7 for Linux, UNIX, and Windows

TIMESTAMP data type allows for parameterized precision

The TIMESTAMP data type is now parameterized to control the precision of the fractional seconds. The range is 0 (no fractional seconds) to 12 (picoseconds). Using the TIMESTAMP data type without a parameter continues to be supported as in previous releases with the default precision of 6 (microseconds).

There are two benefits in having a parameterized TIMESTAMP data type:

An increased maximum precision of 12 improves the granularity of the TIMESTAMP data type.
You can control the precision to meet the needs of your application and use only the storage required to meet those needs. For example, for an application that needs only the date and time, you can now specify a precision of 0, which saves 3 bytes per TIMESTAMP compared to the storage that was required in previous releases.