SQL Reference

Chapter 2 | Supported standards 24
FileMaker also accepts SQL-92 syntax ISO date and time formats with no braces:
1 DATE 'YYYY-MM-DD'
1 TIME 'HH:MM:SS'
1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS'
The FileMaker Pro ExecuteSQL function accepts only the SQL-92 syntax ISO date and time
formats with no braces.
When entering date and time values, match the format of the database file locale. For example, if
the database was created on an Italian language system, use Italian date and time formats.
Exponential/scientific notation
Numbers can be expressed using scientific notation.
Example
SELECT column1 / 3.4E+7 FROM table1 WHERE calc < 3.4E-6 * column2
Numeric operators
You can include the following operators in number expressions: +, -, *, /, and ^ or **
(exponentiation).
You can precede numeric expressions with a unary plus (+) or minus (-).
Constant Acceptable syntax (examples)
Text 'Paris'
Number 1.05
Date DATE '2015-06-05'
{ D '2015-06-05' }
{06/05/2015}
{06/05/15}
Note The 2-digit year syntax is not supported for the ODBC/JDBC format or the SQL-92
format.
Time TIME '14:35:10'
{ T '14:35:10' }
{14:35:10}
Timestamp TIMESTAMP '2015-06-05 14:35:10'
{ TS '2015-06-05 14:35:10'}
{06/05/2015 14:35:10}
{06/05/15 14:35:10}
Make sure Strict data type: 4-Digit Year Date is not selected as a validation option in the
FileMaker database file for a field using this 2-digit year syntax.
Note The 2-digit year syntax is not supported for the ODBC/JDBC format or the SQL-92
format.