MICROSECOND

The MICROSECOND function returns the microsecond part of a value.


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

expression

An expression that returns a value of one of the following built-in data types: a timestamp, a character string, a graphic string, or a numeric data type.

If expression is a character or graphic string, it must not be a CLOB or DBCLOB, and its value must be a valid string representation of a timestamp. For the valid formats of string representations of timestamps, see String representations of datetime values.
If expression is a number, it must be a timestamp duration. For the valid formats of datetime durations, see Datetime operands and durations.

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 character-string representation of a timestamp:
The result is the microsecond part of the value, which is an integer between 0 and 999999.
If the argument is a duration:
The result is the microsecond part of the value, which is an integer between -999999 and 999999. 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)
```