I save my data from my motion detector (Philips Hue) persistently in a PostgreSQL database. Unfortunately the tables look like this:
Timestamp without Timezone | status 2021-07-21 14:35:21 | ON
Is it possible to automatically format the storage of the data in a different table format? So that openHAB automatically saves / transfers them in this format?
Weekday | Date | Time | status 1 | 2021-07-21 | 14:35:21 | ON
Is there a simple and quickly understandable way of doing this? The weekday should then stand 1-7 for Monday - Sunday (think that is also common?)
Thank you in advance and best regards (sorry for bad english )