Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Stats for Db2 13.1.

MICROSECOND

The MICROSECOND function accepts a single argument and returns an integer data type.

MICROSECOND.png

expression must return one of the following built-in data types:

  • TIMESTAMP
  • TIMESTAMP WITH TIMEZONE
  • TIMESTAMP DURATIONA timestamp duration occurs as the result of subtracting two timestamps of precision=6. The result is the microsecond portion of the derived timestamp or timestamp duration.

Important

A CHAR/VARCHAR argument is not accepted unless converted by a TIMESTAMP or TIMESTAMP_TZ function.

If the argument can be null, the result can be null; if the argument value is null, the result is the null value.

Example
MICROSECOND (TIMESTAMP ('1991-12-31-13.30.05.123456'))

results in an integer of value = 123456 It is invalid to specify MICROSECOND (’1991-12-31-13.30.05.123456’) because the argument is of type CHAR.

Example
MICROSECOND (TIMESTAMP ('1991-12-31-13.30.05.123456') - TIMESTAMP ('1991-12-31-13.30.05.123456'))

results in an integer of value = 0


Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*