tested '* 0.5' one, work perfectly ! Thanks !
Le mardi 14 février 2017 17:32:23 UTC+1, Andrew Milner a écrit : > > Both should work > > > On Tuesday, 14 February 2017 18:27:57 UTC+2, wysiwyg wrote: > >> Hello ! >> >> I just discovered this nice SQL command suggested in this discussion: >> >> *UPDATE archive SET barometer=barometer+xxx WHERE dateTime < YYY;* >> >> I'm interested in this to correct an other parameter with multiplication >> instead of addition. >> I just would like to confim the syntax to make sure I will not mess up my >> database: >> so If I want to divide by 2 a value: >> >> *UPDATE archive SET param_to_be_modified=**param_to_be_modified*0.5** WHERE >> dateTime < YYY;* >> >> *or maybe:* >> >> *UPDATE archive SET param_to_be_modified=**param_to_be_modified/2** WHERE >> dateTime < YYY;* >> >> Is one of those working (or both). >> >> Best regards, >> >> >> Le jeudi 12 janvier 2017 00:36:58 UTC+1, Tom Keffer a écrit : >>> >>> Perhaps that's because it was originally translated from a Pascal >>> program <http://www.softwx.com/weather/uwxutils.html>. :-) >>> >>> -tk >>> >>> On Wed, Jan 11, 2017 at 2:07 PM, Gone Bush <goneb...@gmail.com> wrote: >>> >>>> Thanks for the replies, much appreciated. And apologies for the >>>> confusion. >>>> >>>> Tom Keffer's answer with the reference to the uwxutils.py module was >>>> the information is was after. But, being lazy by nature, I was hoping for >>>> a >>>> "here's the formula" type of answer. ;) >>>> >>>> I'm going through the code now and it doesn't seem that bad - even for >>>> a non-Python person. >>>> >>>> -- >>>> 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 weewx-user+...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
