Default language.

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 Check for Db2 13.1.

TIMESTAMP_TZ

The TIMESTAMP_TZ function returns a TIMESTAMP WITH TIME ZONE value from the input arguments.

TIMESTAMP_TZ.png

The arguments are defined as follows:

expression1

expression1 is an expression that returns a value of one of the following built-in data types:

  • TIMESTAMP WITHOUT TIMEZONE
  • TIMESTAMP WITH TIMEZONE
  • Character string representation of timestamp with/out time zone

expression2

If you specify expression2, expression1 must be a timestamp without a time zone, or a string representation of a timestamp without a time zone.

expression2 returns a character string that represents a time zone in the format of ±th:tm with values ranging from -12:59 to +14:00. th represents the time zone hour, and tm represents the time zone minute.

You can specify expression2 as a constant integer in the range of 0 through 12. This value determines the precision of the result.

Important

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

Related topics

TIMESTAMP

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*