OctoPrint-TPLinkSmartplug icon indicating copy to clipboard operation
OctoPrint-TPLinkSmartplug copied to clipboard

[BUG]: sqlite3 schema type for 'timestamp' is 'TEXT' but should be 'DATETIME'

Open puterboy opened this issue 1 year ago • 0 comments

Not a big bug and doesn't affect operation of plugin, but the type of the column timestamp in the schema for the energy_data sqlite3 database should be DATETIME and not TEXT

It would be helpful for those (like me) who want to slurp the database into a pivot table to play with it...

puterboy avatar Feb 06 '24 18:02 puterboy