MySQL Saving Time as Long?

Add-ons Persistence Services
1

Using the MySQL persistence, isn’t it possible to save the time as a Long instead of that string like (“yyyy-mm-dd hh:MM:ss”)?

2

One possible approach is to query the MySQL database using the UNIX_TIMESTAMP(date) function, so you don’t change how item states are persisted, only the format in which you retrieve them:

select UNIX_TIMESTAMP(`Time`),`Value` from Item20;
1 Like
3

Thanks, for that hint!
I guess that will speed up the creating of my chart (in an android app) a lot.

1 Like