Overview

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

The format model does not change the internal expressions of values in the database. When the database converts a string to a date or number, the format model determines how to convert and store this string.

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

• Format of the returned value from the database

• Format of the value stored in the database

OceanBase Database supports the following two types of format models:

• Number format model

• Datetime format model

  Note

  At present, OceanBase Database does not support the FX and FM format modifiers.