hi, i am trying to use the "mysql" example with my own database. my database has a date row formated as timestamp (unixtime) but the example setup function where it uses TimeBucket needs the datetime format.

i tried

->query("SELECT FROM_UNIXTIME(date) FROM MyTableName")

with no success...

how can i convert from timestamp to datetime so the TimeBucket process can use the right format? any help is welcome...

...it seems to generate the chart but with unixtime as the months and it throws errors on the TimeBucket.php in line 131 for every query...

so the .view.php also has to be converted to datetime...but how?

i testet the "from_unixtime()" sql function with my database and it works as expected, it gives me datetime in format yyyy-mm-dd h:i:s why does timebucket throws that error?