Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
puterboy opened this issue Feb 6, 2024 · 0 comments
Open

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

puterboy opened this issue Feb 6, 2024 · 0 comments
Labels
enhancement New feature or request solved workaround documented or fix applied
Milestone
1.0.4

Comments

@puterboy
Copy link

puterboy commented Feb 6, 2024

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...
@jneilliii jneilliii added the enhancement New feature or request label Feb 6, 2024
@puterboy puterboy mentioned this issue Feb 9, 2024
Merged
@jneilliii jneilliii added the solved workaround documented or fix applied label Mar 3, 2024
@jneilliii jneilliii added this to the 1.0.4 milestone Mar 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request solved workaround documented or fix applied
Projects
None yet
Milestone
1.0.4
Development

No branches or pull requests
2 participants
@puterboy @jneilliii