[Maria-discuss] Since MariaDB 10.1 aggregate functions return different field type for columns with date values

Hi all, If I execute the following query on MariaDB 10.1 or later, the result contains a column with a datetime field type (MYSQL_TYPE_DATETIME): SELECT MIN(NOW()) AS t On older versions or any version of MySQL this column is a text type (MYSQL_TYPE_VAR_STRING). https://dev.mysql.com/doc/dev/mysql-server/latest/field__types_8h.html Is there a possibility to use the old behavior in newer version? Best regards, Stefan -- Stefan Langenmaier Senior Operations Engineer makandra GmbH Werner-von-Siemens-Str. 6 86159 Augsburg Fon +49 (0) 821 58866 178 Geschäftsführer: Dr. Thomas Eisenbarth, Henning Koch Amtsgericht Augsburg, HRB 24202