Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 Boolean values can be indicated as true or false. It is case-insensitive.

Dates and Times

No matter the date/date time is complete or partial, it is allowed in AQL as long as it is in ISO8601 date/date time format. Quotes (either single quotes or double quotes) are required to enclose the date/date time value. In AQL grammar, it is treated as a date value if the value is a complete calendar date represented in ISO8601 extended format and if single quotes are used. If the value is in other ISO8601 date/date time format, AQL treats it as a string value, but the AQL query engine processes it differently from a normal string value. It is a temporary solution. In future, a date/date time value should be identified as date/date time value if it is a valid ISO8601 date/date time. Examples are as below:

Code Block

WHERE composition/context/start_time > '19860101' // a complete date. It is a string value within the scope of AQL grammar.
WHERE composition/context/start_time < "120000+0930"  // ISO8601 time. It is a string value within the scope of AQL grammar.

WHERE composition/context/start_time <= '1986-01-01'  // complete calendar date in ISO8601 extended format. It is a date value within the scope of AQL grammar. 

AQL structure

Overview

AQL structure has been briefly introduced in Section 2.2. This section introduces AQL structure in details.

...