Functions of Query Language

The query language has the functions defined that can be used in expressions , in selection fields list and in the filter criterion for the WHERE clause.

The following query language functions are defined:

<Function>

SUBSTRING ( <Expression>, <Value>, <Value> ) |
YEAR ( <Expression> ) |
QUARTER ( <Expression> ) |
MONTH ( <Expression> ) |
DAYOFYEAR ( <Expression> ) |
DAY ( <Expression> ) |
WEEK ( <Expression> ) |
WEEKDAY ( <Expression> ) |
HOUR ( <Expression> ) |
MINUTE ( <Expression> ) |
SECOND ( <Expression> ) |
BEGINOFPERIOD(<Expression>, MINNUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR | TENDAYS | HALFYEAR)
ENDOFPERIOD(<Expression>, MINNUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR | TENDAYS | HALFYEAR)
DATEADD (<Expression>, MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR | TENDAYS | HALFYEAR, <Expression>) DATEDIFFERENCE(<Expression>, <Expression>, SECOND | MINUTE | HOUR | DAY | MONTH | QUARTER | YEAR )
PRESENTATION(<Expression>)
REFPRESENTATION(<Expression>)
ISNULL(<Expression>, <Expression>)
VALUETYPE(<Expression>)