Skip to Content

TIMESTAMP_TZ

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

Related topics

TIMESTAMP

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

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

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.

Warning

Important

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

 

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

BMC AMI Stats for Db2 13.1