DEPRECATION WARNING

This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

SQL function calls¶

It is possible to use any SQL function in the SELECT part of the statement. Function calls are expected to be used with an alias. If this is not the case, an alias will be automatically added. So the following query:

SELECT FROM_UNIXTIME(tstamp, '%Y') FROM tt_content...

would be transformed into:

SELECT FROM_UNIXTIME(tstamp, '%Y') AS function_1 FROM tt_content...

Automatically generated aliases are called “function_” plus the position of the function inside the SELECT part (i.e. the first function is “1”, the second is “2”, etc.).

Note: this feature has been tested with many different functions, but there might be some particular where the SQL parser gets it wrong. If you should stumble on such an issue, don’t hesitate to report it.