try select from_unixtime(dateTime), * from archive where 1; for MySQL and select datetime(dateTime, 'unixepoch', 'local'), * from archive where 1; for SQLite
Should help you on the way On Tuesday, 1 August 2017 10:10:11 UTC+3, David Schulz wrote: > I seem to have weewx data spread across both a MySQL (MariaDB) database as > well as the local SQLite database. > > Why do I think this? I have yearly summaries going back to 2014, but > there are big missing patches. For example, I have data for May 2014, Jan > 2015, Nov, Dec 2016 and all of this year. Weewx is currently writing a > SQLite database on the local machine. I think I inadvertently switched to > SQLite in an upgrade by failing to read properly the messages about > applying the new config file, keeping the old etc... and reverted to the > default local database. > > I previously had setup weewx to write to a MySQL database on another > machine. I believe the 'missing' data is in that database. So the plan is > to merge the 2 data sources, and then reconfigure weewx to write to the > MySQL server. > > The problem I am having is working with the epoch unix integer date and > time data. I'd really like to be able to scan through the data and confirm > my suspicions that the MySQL data fills the missing gaps in the SQLite > data. I've tried half a dozen different database tools in the hope one has > an option to display the epoch date and time in a human readable format I > can work with. Anybody got any recommendations? > > Of course I've seen many, many query examples to convert a single row of > data from epoch to a human readable format. What I really need though is > to be able to scan down the table data and see what I have in each > location. Or maybe I am thinking about the problem the wrong way? > > Maybe a better approach is to rename the existing weewx database in MySQL > to avoid it being overwritten and then use wee_database --transfer to at > least get everything in MySQL and then work on merging the legacy data? > > Any advice from wiser heads will be appreciated. > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
