ODBC and JDBC Guide

54 FileMaker ODBC and JDBC Guide
Functions that return dates
Note The DATE() function is deprecated. Use the SQL standard CURRENT_DATE instead.
Operator precedence
As expressions become more complex, the order in which the expressions are evaluated becomes important.
This table shows the order in which the operators are evaluated. The operators in the first line are evaluated
first, and so on. Operators in the same line are evaluated left to right in the expression.
SIGN An indicator of the sign of the argument: -1 for negative, 0
for 0, and 1 for positive.
SIN Returns the sine of the argument
SQRT Returns the square root of the argument
TAN Returns the tangent of the argument
VA L Converts a character string to a number; if the character
string is not a valid number, returns 0
VAL('123') returns 123
X Returns the decimal equivalent of a hexadecimal number X'b9' returns 185
YEAR Returns the year part of a date YEAR({d '2010/01/30'}) returns 2010
Functions that return
dates Description Example
CURDATE
CURRENT_DATE
Returns today’s date
CURTIME
CURRENT_TIME
Returns the current time
CURTIMESTAMP
CURRENT_TIMESTAMP
TIMESTAMPVAL
Returns the current timestamp value
DATE
TODAY
Returns today’s date If today is 11/21/2010, DATE() returns 2010-11-21
DATEVAL Converts a character string to a date DATEVAL('01/30/2011') returns 2011-01-30
Precedence Operator
1 Unary '-', Unary '+'
2 ^, **
3 *, /
4 +, -
5 =, <>, <, <=, >, >=, Like, Not Like, Is Null, Is Not Null, Between, In, Exists, Any, All
6 Not
7 AND
8 OR
Functions that
return numbers Description Example