I am not sure if this is a bug or invalid mysql. In both cases it returns using python-mysqlclient a string instead of the correct Datetime object.
The Mysql workbench on Archlinux returns the result as a string as expected. On my collegues machine Mysql workbench returns Blob, when you click on it, it shows the string. I have tested this query against mysql 5.6,5.7, percona 8, mariadb. So far mariadb was the only server that returned the correct data type.
SELECT MIN(CAST('2018-01-01 00:00:00' AS datetime)),MIN(TIMESTAMP('2018-01-01 00:00:00'));
So my question is, is this a bug?