Axiom Processing Language supplies a set of system data types that define all the types of data that can be used with APL.

The following table lists the data types supported by APL, alongside additional aliases you can use to refer to them.

TypeAdditional name(s)gettype()
bool()booleanint8
datetime()datedatetime
dynamic()array or dictionary or any other of the other values
int()int has an alias longint
long()long
real()doublereal
string()string
timespan()timetimespan

The bool data type

The bool (boolean) data type can have one of two states: true or false (internally encoded as 1 and 0, respectively), as well as the null value.

bool literals

The bool data type has the following literals:

  • true and bool(true): Representing trueness
  • false and bool(false): Representing falsehood
  • null and bool(null): Representing the null value

bool operators

The bool data type supports the following operators: equality (==), inequality (!=), logical-and (and), and logical-or (or).

The datetime data type

The datetime (date) data type represents an instant in time, typically expressed as a date and time of day. Values range from 00:00:00 (midnight), January 1, 0001 Anno Domini (Common Era) through 11:59:59 P.M., December 31, 9999 A.D. (C.E.) in the Gregorian calendar.

datetime literals

Literals of type datetime have the syntax datetime (value), where a number of formats are supported for value, as indicated by the following table:

ExampleValue
datetime(2019-11-30 23:59:59.9) datetime(2015-12-31)Times are always in UTC. Omitting the date gives a time today.
datetime(null)Check out our null values
now()The current time.
now(-timespan)now()-timespan
ago(timespan)now()-timespan

now() and ago() indicate a datetime value compared with the moment in time when APL started to execute the query.

Supported formats

We support the ISO 8601 format, which is the standard format for representing dates and times in the Gregorian calendar.

ISO 8601

FormatExample
%Y-%m-%dT%H:%M:%s%z2016-06-26T08:20:03.123456Z
%Y-%m-%dT%H:%M:%s2016-06-26T08:20:03.123456
%Y-%m-%dT%H:%M2016-06-26T08:20
%Y-%m-%d %H:%M:%s%z2016-10-06 15:55:55.123456Z
%Y-%m-%d %H:%M:%s2016-10-06 15:55:55
%Y-%m-%d %H:%M2016-10-06 15:55
%Y-%m-%d2014-11-08

The dynamic data type

The dynamic scalar data type is special in that it can take on any value of other scalar data types from the list below, as well as arrays and property bags. Specifically, a dynamic value can be:

  • null
  • A value of any of the primitive scalar data types: bool, datetime, int, long, real, string, and timespan.
  • An array of dynamic values, holding zero or more values with zero-based indexing.
  • A property bag, holding zero or more key-value pairs.

Dynamic literals

A literal of type dynamic looks like this:

dynamic (Value)

Value can be:

  • null, in which case the literal represents the null dynamic value: dynamic(null).
  • Another scalar data type literal, in which case the literal represents the dynamic literal of the “inner” type. For example, dynamic(6) is a dynamic value holding the value 6 of the long scalar data type.
  • An array of dynamic or other literals: [ListOfValues]. For example, dynamic([3, 4, “bye”]) is a dynamic array of three elements, two long values and one string value.
  • A property bag: {Name=Value ...}. For example, dynamic(\{"a":1, "b":\{"a":2\}\}) is a property bag with two slots, a, and b, with the second slot being another property bag.

The int data type

The int data type represents a signed, 64-bit wide, integer.

The special form int(null) represents the null value.

int has an alias long

The long data type

The long data type represents a signed, 64-bit wide, integer.

long literals

Literals of the long data type can be specified in the following syntax:

long(Value)

Where Value can take the following forms:

  • One more or digits, in which case the literal value is the decimal representation of these digits. For example, long(11) is the number eleven of type long.
  • A minus (-) sign followed by one or more digits. For example, long(-3) is the number minus three of type long.
  • null, in which case this is the null value of the long data type. Thus, the null value of type long is long(null).

The real data type

The real data type represents a 64-bit wide, double-precision, floating-point number.

The string data type

The string data type represents a sequence of zero or more Unicode characters.

String literals

There are several ways to encode literals of the string data type in a query text:

  • Enclose the string in double-quotes("): “This is a string literal. Single quote characters (’) don’t require escaping. Double quote characters (”) are escaped by a backslash (\)“
  • Enclose the string in single-quotes ('): Another string literal. Single quote characters (’) require escaping by a backslash (\). Double quote characters (”) do not require escaping.

In the two representations above, the backslash (\) character indicates escaping. The backslash is used to escape the enclosing quote characters, tab characters (\t), newline characters (\n), and itself (\\).

Raw string literals

Raw string literals are also supported. In this form, the backslash character (\) stands for itself, and does not denote an escape sequence.

  • Enclosed in double-quotes(""): @“This is a raw string literal”
  • Enclose in single-quotes('): @‘This is a raw string literal’

Raw strings are particularly useful for regexes where you can use @”^[\d]+"insteadof"[d]+"** instead of **"^[\\d]+

The timespan data type

The timespan (time) data type represents a time interval.

timespan literals

Literals of type timespan have the syntax timespan(value), where a number of formats are supported for value, as indicated by the following table:

Valuelength of time
2d2 days
1.5h1.5 hour
30m30 minutes
10s10 seconds
timespan(15s)15 seconds
0.1s0.1 second
timespan(2d)2 days

Type conversions

APL provides a set of functions to convert values between different scalar data types. These conversion functions allow you to convert a value from one type to another.

Some of the commonly used conversion functions include:

  • tobool(): Converts input to boolean representation.
  • todatetime(): Converts input to datetime scalar.
  • todouble() or toreal(): Converts input to a value of type real.
  • tostring(): Converts input to a string representation.
  • totimespan(): Converts input to timespan scalar.
  • tolong(): Converts input to long (signed 64-bit) number representation.
  • toint(): Converts input to an integer value (signed 64-bit) number representation.

For a complete list of conversion functions and their detailed descriptions and examples, refer to the Conversion functions documentation.