For the latest version of JMP Help, visit

JSL Syntax Reference > SQL Functions Available for JMP Queries
Publication date: 11/10/2021

SQL Functions Available for JMP Queries

The Query() JSL function performs a SQL query on selected tables and exports the data to a data table. The following example first assigns the t1 alias to Big name, age greater than 13, and height are then selected from the t1 table.

dt = Open( "$SAMPLE_DATA/Big" );
Query( Table( dt, "t1" ),
       "SELECT, t1.age, t1.height FROM t1
       WHERE t1.age > 13" );

You can use SQL functions in a query. For example, SELECT CURRENT_TIMESTAMP returns the current UTC/GMT time stamp as a SQLite time string:


This appendix lists the numeric, date-time, string, system SQL, and aggregate functions that you can use in SQL queries. “Yes” in the SQLite column indicates native SQLite functions. See the Online SQLite documentation at


Numeric SQL Functions

Date-Time SQL Functions

String SQL Functions
System SQL Functions

Aggregate SQL Functions

Want more information? Have questions? Get answers in the JMP User Community (