Is there an easy way to get leading 0’s on month() and monthDay() returns that are single digits, when inserting into a string?
yes. I am pretty sure that I have already done that, but I don’t remember how.
possible a regex is the best way to do it but I don’t remember if regex function on Influx DB allows that.
the fastest thing that comes to my mind is as follows:
let’s say you are at month 7, add 900, then the result will be 907 (Integer) then convert to string the result will be ‘907’ then use some of the substring or replace or trim functions to get rid of the first ‘9’, the result will be the string. ‘07’