How to find the EXASOL server version with SQL

Question

I'm looking for a SQL query to provide me with the Exasol server version, similar to this in Oracle:

-- Oracle
select * from v$version;

-- PostgreSQL:
select version();

How can I do it?

Answer 1

This seems to work:

select param_value from exa_metadata where param_name = 'databaseProductVersion';

Answer 2

This is also an option:

select *
from "$ODBCJDBC".DB_METADATA
where name in (
      'databaseIncrementVersion'
    , 'databaseMajorVersion'
    , 'databaseMinorVersion'
    , 'databaseProductVersion'
    , 'databaseName'
    , 'databaseProductName'
    , 'revisionNumber');