Content Comparison

Refers to timestamp (as per ISO8601)

Typical Formats: yyyy-mm-dd hh:mm:ss or yyyy-mm-ddThh:mm:ss (see all accepted formats).

Note:

• yyyy = year in 4 digits. For example, 2015.
• mm = month in 2 digits, from 01 (for January) to 12 (for December).
• dd = day of month in 2 digits, from 01 to 31.
• hh = hour in 2 digits, from 00 to 23.
• mm = minute in 2 digits from 00 to 59.
• ss = second in 2 digits from 00 to 59.
• T = Letter T can be inserted between yyyy-mm-dd and hh:mm:ss instead of space.
• Z = Letter Z refers to zero meridian and can be appended (optional) to hh:mm:ss.

The time format represents Coordinated Universal Time (UTC). For example, 2015-09-03 13:50:00 or 2015-09-03T13:50:00Z represents 01:50 p.m. (UTC) on September 09, 2015.

Time Zones:

The strings +hh:mm, +hhmm, -hh:mm, -hhmm can be appended to yyyy-mm-dd hh:mm:ss in order to specify a time zone relative to UTC. For example, UTC+5:30 represents Indian Standard Time (IST) and hence 2015-09-03 13:50:00+05:30 represents 01:50 p.m. (IST) on September 09, 2015.

Accepted date and time formats:

a. yyyy-mm-dd hh:mm:ss+hh:mm

b. yyyy-mm-dd hh:mm:ss+hhmm

c. yyyy-mm-dd hh:mm:ss-hh:mm

d. yyyy-mm-dd hh:mm:ss-hhmm

Note:

a. In all of the above, the space between yyyy-mm-dd and hh:mm:ss can be replaced with the letter T. For example, both 2015-09-30 12:00:00 and 2015-09-30T12:00:00 are acceptable.

b. In all of the above the letter Z can be appended to hh:mm:ss. Both hh:mm:ss and hh:mm:ssZ refer to time in UTC. For example, both 2015-09-30T12:00:00 and 2015-09-30T12:00:00Z refer to the same time in UTC .

The Boolean data type has one of two possible values (usually denoted "true" and "false" or "0" or "1").

The Int data type represents a range of mathematical integers (whole numbers without decimals).

Numeric data types are decimal numbers.