Difference between revisions of "Database Format"
From AgileApps Support Wiki
imported>Aeric (Created page with "The ''database format'' is the format in which data is stored in the database. :{| border="1" cellpadding="3" class="tight-rows" ! Field !! Format |- | Date, DateTime, Date || [...") |
imported>Aeric |
||
| Line 3: | Line 3: | ||
! Field !! Format | ! Field !! Format | ||
|- | |- | ||
| Date, DateTime, Date || [[UTC Format]] | | '''Date, DateTime, Date''' || [[UTC Format]] | ||
|- | |- | ||
| | | '''Currency, Number, Number with Decimal, Percent''' | ||
| | | | ||
* No currency symbol or percent sign | * No currency symbol or percent sign | ||
Revision as of 18:52, 22 August 2013
The database format is the format in which data is stored in the database.
Field Format Date, DateTime, Date UTC Format Currency, Number, Number with Decimal, Percent - No currency symbol or percent sign
- No grouping characters for whole number amounts
- A decimal point (.) before fractional amounts
Ex: 84954.32