formula syntax-data type

Data Type

Type Description

Numeric Integer int 32-bit two's complement Defines a field containing a whole number between -2,147,483,648 and 2,147,483,647. Fractional values inserted into an integer field are truncated. If specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.

long 64-bit two's complement A data type that holds large integers.

BigInt Immutable arbitrary-precision integers.

Real Number float 32-bit IEEE 754 This data type defines an 32bit-IEEE standard 754 floating-point field. Floating-point fields can be defined as single or double (default) precision based on the value of integer. If the value of integer is between 1 and 21, the type is single precision floating-point, which requires 4 bytes of storage. If the value of integer is between 22 and 53 inclusive, the type is double precision floating-point, which requires 8 bytes of storage. If a field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.

double 64-bit IEEE 754 This data type defines an 64-bit IEEE standard 754 floating-point field. Floating-point fields can be defined as single or double (default) precision based on the value of integer. If the value of integer is between 22 and 53 inclusive, the type is double precision floating-point, which requires 8 bytes of storage. If a field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.

currency This data type contains a dollar amount between -10¹² and 10¹² and is displayed in a user-defined format.

Type	Description
Numeric	Integer	int	32-bit two's complement	Defines a field containing a whole number between -2,147,483,648 and 2,147,483,647. Fractional values inserted into an integer field are truncated. If specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.
long	64-bit two's complement	A data type that holds large integers.
BigInt		Immutable arbitrary-precision integers.
Real Number	float	32-bit IEEE 754	This data type defines an 32bit-IEEE standard 754 floating-point field. Floating-point fields can be defined as single or double (default) precision based on the value of integer. If the value of integer is between 1 and 21, the type is single precision floating-point, which requires 4 bytes of storage. If the value of integer is between 22 and 53 inclusive, the type is double precision floating-point, which requires 8 bytes of storage. If a field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.
double	64-bit IEEE 754	This data type defines an 64-bit IEEE standard 754 floating-point field. Floating-point fields can be defined as single or double (default) precision based on the value of integer. If the value of integer is between 22 and 53 inclusive, the type is double precision floating-point, which requires 8 bytes of storage. If a field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.
currency		This data type contains a dollar amount between -10¹² and 10¹² and is displayed in a user-defined format.

Type Description

Date/Time date MM/dd/yy MM/dd/yyyy Dates designate a point in time according to the Gregorian calendar. Historical dates may not follow this calendar. The standard input format for this data type is MM/dd/yy or MM/dd/yyyy (automatic conversion is performed between these two formats).

time HH:mm:ss
hh:mm:ss The time field data type is defined by the standard input format of HH:mm:ss (using hour in day 0--23) or hh:mm:ss (using in am/pm 1--12).

timestamp yyyy-MM-dd hh:mm:ss This combination date and time data type is displayed in the format yyyy-MM-dd-HH: mm.ss.nnnnnnn.

Other Types char 16-bit Unicode character A single character.

string A data type that holds character information.

Boolean true or false True or false.

Notes:

Format Description

yyyy An integer from 0001 to 9999, representing a year.

MM An integer from 1 to 12 representing a month

dd An integer from 1 to 31 (maximum depends on the month and year) representing the day of the month

HH An integer from 0 to 23, representing the hour in day

hh An integer from 1 to 12, representing the hour in am/pm.

mm An integer from 0 to 59, representing minutes

ss An integer from 0 to 59 representing seconds (default 0)

nnnnnn An integer (up to 6 digits) representing microseconds. If any trailing digit is omitted, 0 is assumed

Type	Description
Date/Time	date	MM/dd/yy MM/dd/yyyy	Dates designate a point in time according to the Gregorian calendar. Historical dates may not follow this calendar. The standard input format for this data type is MM/dd/yy or MM/dd/yyyy (automatic conversion is performed between these two formats).
time	HH:mm:ss hh:mm:ss	The time field data type is defined by the standard input format of HH:mm:ss (using hour in day 0--23) or hh:mm:ss (using in am/pm 1--12).
timestamp	yyyy-MM-dd hh:mm:ss	This combination date and time data type is displayed in the format yyyy-MM-dd-HH: mm.ss.nnnnnnn.
Other Types	char	16-bit Unicode character	A single character.
string		A data type that holds character information.
Boolean	true or false	True or false.

Format	Description
yyyy	An integer from 0001 to 9999, representing a year.
MM	An integer from 1 to 12 representing a month
dd	An integer from 1 to 31 (maximum depends on the month and year) representing the day of the month
HH	An integer from 0 to 23, representing the hour in day
hh	An integer from 1 to 12, representing the hour in am/pm.
mm	An integer from 0 to 59, representing minutes
ss	An integer from 0 to 59 representing seconds (default 0)
nnnnnn	An integer (up to 6 digits) representing microseconds. If any trailing digit is omitted, 0 is assumed

Index