Author Topic: Store SQL Data with same precision as the *.Cat files  (Read 1432 times)

monymony

  • Strong Breeze
  • ***
  • Posts: 173
  • CoCoRaHS - MD-CC-16
    • EW3643
    • KMDELKTO10
    • Cecil County Maryland Weather
  • Station Details: Davis Vantage Pro 2
Store SQL Data with same precision as the *.Cat files
« on: February 26, 2016, 01:06:43 PM »
I have recently written a custom sql view/function to calculate my stations all-time hi/low records for the current date.  I could not figure out why my calculated values from SQL where off by ?0.1?F.  Finally I discovered that the SQL data is storing the temperature in ?C to one decimal place but the weathercat *.cat file is storing the same temperature reading to two decimal places.  Since I need to convert from Celsius to Fahrenheit this difference in the number of decimal places is throwing my calculations off (see screenshot from my website for an example). 

Can the SQL data be changed to allow for the same number of decimal places as is stored in the *.cat files? 

Thanks!



WCDev

  • WeatherCat Developer
  • Administrator
  • Storm
  • *****
  • Posts: 2911
    • CW9739
    • ISCOTLAN25
    • Trixology
  • Station Details: Main Station: Vantage Pro-2, 24hr fars, solar, soil/leaf station, extra temp stations, no U.V. WeatherLink IP.
Re: Store SQL Data with same precision as the *.Cat files
« Reply #1 on: February 26, 2016, 09:45:25 PM »
Added, I'll look into it thanks  [tup] (#201)