Difference between revisions of "Database Format"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 1: | Line 1: | ||
The ''database format'' is the format in which data is stored in the database. | The ''database format'' is the format in which data is stored in the database. | ||
: ''See also:'' [[User Format]] | |||
:{| border="1" cellpadding="3" | :{| border="1" cellpadding="3" | ||
| '''''Field''''' || '''''Format''''' | | '''''Field''''' || '''''Format''''' | ||
Line 5: | Line 7: | ||
| '''Date, DateTime, Date''' || [[UTC Format]] | | '''Date, DateTime, Date''' || [[UTC Format]] | ||
|- | |- | ||
| '''Currency, Number, Number with Decimal, Percent''' | | valign="top" | '''Currency, Number,<br>Number with Decimal, Percent''' | ||
| | | | ||
* No currency symbol or percent sign | * No currency symbol or percent sign |
Revision as of 18:56, 22 August 2013
The database format is the format in which data is stored in the database.
- See also: User Format
Field Format Date, DateTime, Date UTC Format Currency, Number,
Number with Decimal, Percent- No currency symbol or percent sign
- No grouping characters (e.g. commas) in whole-number portion
- A decimal point (.) before fractional portion
Ex: 84954.32