SQL Reference

MICROSECOND

>>-MICROSECOND--(--expression--)-------------------------------><
 

The schema is SYSIBM.

The MICROSECOND function returns the microsecond part of a value.

The argument must be a timestamp, timestamp duration or a valid character string representation of a timestamp that is neither a CLOB nor a LONG VARCHAR.

The result of the function is a large integer. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

The other rules depend on the data type of the argument:

• If the argument is a timestamp or a valid string representation of a timestamp:

  • The integer ranges from 0 through 999 999.

• If the argument is a duration:

  • The result reflects the microsecond part of the value which is an integer between -999 999 through 999 999. A nonzero result has the same sign as the argument.

Example:

• Assume a table TABLEA contains two columns, TS1 and TS2, of type TIMESTAMP. Select all rows in which the microseconds portion of TS1 is not zero and the seconds portion of TS1 and TS2 are identical.

    SELECT * FROM TABLEA
      WHERE MICROSECOND(TS1) <> 0 AND
      SECOND(TS1) = SECOND(TS2)
  

[ DB2 List of Books | Search the DB2 Books ]