![]() ![]() For such formats, you can specify the characters returned by these format elements implicitly using the initialization parameter NLS_TERRITORY. The values of some formats are determined by the value of initialization parameters. The number format model for the string ' $2,304.25' is ' $9,999.99'.įor lists of number and datetime format model elements, see Table 2-17, "Matching Character Data and Format Models with the FX Format Model Modifier" and Table 2-19, "Attributes of the XMLFormat Object". The datetime format model for the string ' 1' is ' DD-Mon-YYYY'. The datetime format model for the string ' 17:45:29' is ' HH24:MI:SS'. The format for a value you have specified for Oracle to store in the database ![]() ![]() The format for Oracle to use to return a value from the database In SQL statements, you can use a format model as an argument of the TO_CHAR and TO_DATE functions to specify: When you convert a character string into a date or number, a format model determines how Oracle Database interprets the string. A format model does not change the internal representation of the value in the database. A format model is a character literal that describes the format of datetime or numeric data stored in a character string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |