SQL Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Supported standards
- Support for Unicode characters
- SQL statements
- SELECT statement
- SQL clauses
- FROM clause
- WHERE clause
- GROUP BY clause
- HAVING clause
- UNION operator
- ORDER BY clause
- OFFSET and FETCH FIRST clauses
- FOR UPDATE clause
- DELETE statement
- INSERT statement
- UPDATE statement
- CREATE TABLE statement
- TRUNCATE TABLE statement
- ALTER TABLE statement
- CREATE INDEX statement
- DROP INDEX statement
- SQL expressions
- SQL functions
- FileMaker system objects
- Reserved SQL keywords
- Index
Chapter 2 | Supported standards 24
For ODBC and JDBC applications, FileMaker accepts the ODBC/JDBC format date, time, and
timestamp constants in braces ({}).
Examples
FileMaker allows the type specifier (D, T, TS) to be in upper case or lower case. You may use any
number of spaces after the type specifier, or even omit the space.
FileMaker also accepts SQL-92 syntax ISO date and time formats with no braces.
Examples
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.
1 {D '2019-06-05'}
1 {T '14:35:10'}
1 {TS '2019-06-05 14:35:10'}
1 DATE 'YYYY-MM-DD'
1 TIME 'HH:MM:SS'
1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS'
Constant Acceptable syntax (examples)
Text 'Paris'
Number 1.05
Date DATE '2019-06-05'
{ D '2019-06-05' }
{06/05/2019}
{06/05/19}
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 '2019-06-05 14:35:10'
{ TS '2019-06-05 14:35:10'}
{06/05/2019 14:35:10}
{06/05/19 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.