Format for Date/Time field Result
dd-mm-yy 25-12-12
mm/dd/yy 12/25/12
yyyy/mm/dd 2012/12/25
dd mmm yyyy 25 Dec 2012


Field Size for Number field Description
Byte For integers that range from 0 to 255. Storage requirement is a single byte.
Integer For integers that range from -32,768 to +32,767. Storage requirement is two bytes.
Long integer For integers that range from -2,147,483,648 to +2,147,483,647. Storage requirement is four bytes.
Single For numeric floating point values that range from -3.4 x 1038 to +3.4 x 1038 and up to seven significant digits. Storage requirement is four bytes.
Double For numeric floating point values that range from -1.797 x 10308 to +1.797 x 10308 and up to 15 significant digits. Storage requirement is eight bytes.
Decimal For numeric values that range from -9.999... x 1027 to +9.999... x 1027. Storage requirement is 12 bytes.