MySQL Forums
Forum List  »  General

Re: Join based on closest timestamp
Posted by: Holger A.
Date: April 05, 2018 04:37PM

ok somehow my message is not appearing here. I'll give it a second try. :)

I uploaded the files here: www. rapi dsha re.co m.cn/j0uHwkg (remove spaces).


the vzdata2018-04-04.csv needs to go into this table:

#Database volkszaehler
#in this table are more timestamps available than required
CREATE TABLE `data` (
`timestamp` bigint(20) NOT NULL, #created by the application - unix timestamp
`value` double NOT NULL
)
;

sbfdata2018-04-04.csv needs to go into this table:
#Database sbfspot-man
#"master" for available timestamps
CREATE TABLE `data` (
`timestamp` datetime NOT NULL, #created by the application in format yyyy-mm-dd hh:mm:ss
`timestamp-unix` bigint(20) NOT NULL, #transformation with sql to unix timestamp
`watt-pactot` decimal(15,4) DEFAULT NULL
)
;


KR
Holger

Options: ReplyQuote


Subject
Written By
Posted
Re: Join based on closest timestamp
April 05, 2018 04:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.