Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Date And Time Functions (XDB Mode) > MICROSECOND

MICROSECOND

Restriction: This topic applies to Windows environments only.
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
Parent topic: Date And Time Functions (XDB Mode)
Previous Topic Next topic Print topic