Catchup Custom MySQL
Posted: Tue 11 Mar 2025 3:04 am
How do I put the correct time in a MySQL database table with the catchup custom MySQL. The time of the Ecowitt observation is not used. The time that is used is the time when it is written to the database not the time of the observation. Is it possible to insert the date and time as per the Monthly SQL update (Logdatetime) during catchup.
The MySQL used:
INSERT IGNORE INTO extralogssensors (DateTime, Time, Date, YearMonth , FourthTemp , FourthHumidity , Temp , Humidity , ExtraOutTemp , ExtraOutHum , InsideTemp , InsideHum , VioletTemp , VioletHum , SoilMoisture1 , SoilMoisture2 , SoilMoisture3 ) VALUES ('<#date > <#timehhmmss >','<#timehhmmss >','<#date >','<#year>-<#month>',<#ExtraTemp1>,<#ExtraHum1>,<#temp>,<#hum>,<#ExtraTemp2>,<#ExtraHum2>,<#intemp>,<#inhum>, <#ExtraTemp3>,<#ExtraHum3>,<#SoilMoisture1>,<#SoilMoisture2>,<#SoilMoisture3> );
Attached a diagnostic file and the image of the database table
The MySQL used:
INSERT IGNORE INTO extralogssensors (DateTime, Time, Date, YearMonth , FourthTemp , FourthHumidity , Temp , Humidity , ExtraOutTemp , ExtraOutHum , InsideTemp , InsideHum , VioletTemp , VioletHum , SoilMoisture1 , SoilMoisture2 , SoilMoisture3 ) VALUES ('<#date > <#timehhmmss >','<#timehhmmss >','<#date >','<#year>-<#month>',<#ExtraTemp1>,<#ExtraHum1>,<#temp>,<#hum>,<#ExtraTemp2>,<#ExtraHum2>,<#intemp>,<#inhum>, <#ExtraTemp3>,<#ExtraHum3>,<#SoilMoisture1>,<#SoilMoisture2>,<#SoilMoisture3> );
Attached a diagnostic file and the image of the database table