i'm using interval node and inserting data to mysql ,everything works if i insert the time in milliseconds...
i want to insert it directly into human readable form, the interval node outputs the human readable as 1m 30s and for some reason i can't insert that into mysql
i tried different columns time, int, varchar nothing seems to work is there another node that can transform time to mysql format? i'l take any help i can get
Why? Usually that is a bad idea, put it in the db in a timestamp column (in UTC) then convert it for display in your particular timezone when you read it out. That way you can query on timestamp ranges and so on. Also applications such as Grafana expect the timestamp in that form.
Colin it's a counter it counts the time between payloads why would i put it in a timestamp it doesn't make sense , i'm trying to have a sort of reporting StartDate EndDate and counter...i already have a timestamp for StartDate ...
it wont make sense to put 1m and 30 s in milliseconds in timestamp unless i'm wrong...and an int column would do the same thing u can add and subtract with the timestamp...i just want to insert it in human readable form so i don't have to do extra query's
1m 30s
is not an int(eger) and not time, but it is a varchar and you should be able to insert it.
Then again, to keep records an actual timestamp is a better idea.
i tried to insert it in a varchar 60 column ,the column stays null or more exactly zero (0)
and i am pretty sure u can't insert milliseconds in a timestamp it will stay as 0
i'm using the same query in the function node it works with milliseconds but it wont work with "1m30s" i can see the output in the debug node, it returns an error ( check your maria db ta ta ta usual error)
it's nothing to complicated gpioin node----> interval-length node----> function node----->mysql
i was hoping maybe there was a node that would transform the time to mysql friendly time...without the m and s it should be 00 01 30
Pretty sure there is something incorrect in your query. Did you enclose the field in single quotes ?
Post the output of a debug node showing what you are feeding to your sql node, and the error that the sql node is generating.
Personally, I would store it as a BIGINT in milliseconds. Then you can use it both for display and for calculations.
+1 to that.
that's what i was doing totally ,but since i don't really need it for any calculations i wanted to insert it as is,i'm just gonna generate a column
Thank you guys
