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