Not the answer you need?
Register and ask your own question!

Aggregation functions on Datetime(6) and Timestamps Change the return type

mkuhnmkuhn EntrantLegacy User Role Novice

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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.