Format Models

1

Number formats

Supported, with differences.

GaussDB supports the $, C, TM, TM9, TME, and U formats only when a_format_version is set to 10c and a_format_dev_version is set to s1. In addition, this parameter does not support the TH, PL, or SG format.

For details about GaussDB, see the fmt parameter of the number type table in "SQL Reference > Functions and Operators > Type Conversion Functions" in Developer Guide.

2

Datetime formats

Supported, with differences.

GaussDB: Parameters used for time truncation and rounding are valid only when a_format_version is set to 10c and a_format_dev_version is set to s1.

For details about GaussDB support, see formats for formatting date and time in "SQL References > Functions and Operators > Date and Time Processing Functions and Operators" in Developer Guide.

3

Format model modifiers

Supported.

-

4

String-to-date conversion rules

Supported, with differences.

GaussDB: The to_timestamp_tz function is valid only when a_format_version is set to 10c and a_format_dev_version is set to s1.

For details about GaussDB, see to_date, to_timestamp, and to_timestamp_tz in "SQL Reference > Functions and Operators > Type Conversion Functions" in Developer Guide.

5

XML format models

Not supported.

-