Formatting models

In OceanBase Database in Oracle mode, you can use formatting models to specify the format of date and time data or numeric data stored in the database.

Formatting models do not change the internal representation of values in the database. When the database converts a string to a date or number, the formatting model determines how to convert and store the string.

In SQL statements, you can use formatting models as parameters for functions such as TO_CHAR, TO_NUMBER, and TO_DATE to specify the following formats:

• The format of values returned by the database

• The format of values stored in the database

OceanBase Database supports the following two data formatting models:

• Numeric formatting models

• Date and time formatting models

  Note

  OceanBase Database does not support the FX and FM formatting modifiers.