Difference between revisions of "Database Format"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 8: Line 8:
|
|
* No currency symbol or percent sign
* No currency symbol or percent sign
* No grouping characters for whole number amounts
* No grouping characters (e.g. commas) in whole-number portion
* A decimal point (.) before fractional amounts
* A decimal point (.) before fractional portion
''Ex:'' 84954.32
''Ex:'' 84954.32
|}
|}

Revision as of 18:55, 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 (e.g. commas) in whole-number portion
  • A decimal point (.) before fractional portion

Ex: 84954.32