Overview

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

Specifying a format model does not change the internal expressions of the values in the database. When you convert a string to a date or number in the database, the specified format decides the method of converting and storing this string.

In SQL statements, you can use a format model as the parameter of the TO_CHAR, TO_NUMBER, and TO_DATE functions to specify the following formats:

• The format of the returned values

• The format of values stored in the database

OceanBase Database supports the following data format models:

• Number format model

• Datetime format model

  Note

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