| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X | X |
This function is used to extract the microsecond part of a timestamp. The result is an integer between 0 and 999999 (or null if time-expr evaluates to a null value). The format appears below:
MICROSECOND(time-expr)
For example:
SELECT MICROSECOND(audit_time) FROM tasks