cant display visual - data type year from database

[aracoustic30]

I want to display year data from a database that is connected by direct query to mariadb. when the year column has the type YEAR an error 'cannot display the visual' appears. in another table there is a year column with the INETEGER data type which does not experience errors when I try to visualize it. what can I do to deal with that YEAR type data?

[Anonymous · Accepted solution]

Hi @aracoustic30 ,

I think the reason for such problems should ensure that all the values in the YEAR  column are within the acceptable range for MariaDB. Also if the visual tool you’re using doesn’t support the YEAR data type directly, you might need to convert the YEAR column to a different format. You can also read this document: mariadb.com

I think you also can right click on the Date column and select Change Type > Using Locale... In the Change Type window, select Date for Data Type, English (United Kingdom) or other locales which has the same date format as your original Date column input. This should change the type into Date correctly.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.