Forum Discussion
cant display visual - data type year from database
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?
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.
1 Reply
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.