The Elearning Community • Google Data Studio / JDBC - MySQL and Empty Date Fields
Page 1 of 1

Google Data Studio / JDBC - MySQL and Empty Date Fields

Posted: Fri Jan 22, 2021 2:03 pm
by scubatricky
The database definition may need to be amended to ensure that the date fields within tables that do not contain actual dates are defined to NULL by default, as the JDBC driver for Google Data Studio does not accept zero'd date fields.

I'm not aware that this will cause and issue inside Forma LMS itself, as it doesn't seem to care if a date field is NULL or zero-filled?

At present, Google Data Studio using the JDBC driver to connect to the database will not return date fields that are zero-filled as the driver does not recognise it as a date. This would apply to Google Sheets also.

Maybe a fix for the future?

This site uses cookies.

Some of the cookies we use are essential for parts of the site to operate and have already been set. We also use Google Analytics scripts, which all use cookies.
You may delete or block all cookies from this site in your browser options.