Overview

In OceanBase Database in Oracle mode, you can use a format model to specify the format of datetime data or numeric data stored in the database.

The format model does not change the internal representations of values in the database. When the database converts a string into a date or number, the format model determines how the string is to be converted and stored.

In SQL statements, you can use format models as parameters of the TO_CHAR, TO_NUMBER, and TO_DATE functions 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 data format models:

• Number format models

• Datetime format models

Note

At present, OceanBase Database does not support the FX or FM format model modifier.