Insert minute on data base

[jespinmartin1]

now print MemTimeDiffm I bet I’ll be 0.
Advice: you should store timeDuration in float8 minutes or bigint seconds is like a standard. Then you may retrieve and decode with less work, and you’ll avoid this approach.

[WillMT10]

I did a quick test earlier today to make sure I was thinking correctly. When you read a non-existent tag, and cast to int(), you get -1. At that point you would still expect 23:59:00 but still felt worth calling out.

[nminchin]

@jespinmartin1

Advice: you should store timeDuration in float8 minutes or bigint seconds

Or better yet, just store the date. Then you have the ultimate flexibility

[antonio.sanchez]

Hi

They are in the same root folder “Linea Disco” but the tag where the insert script is found is in a sub folder of the root folder “COnteo Falla Disco”.

[antonio.sanchez]

The same thing happens to me on line 9 and 12

but the tag is telling me the times

[antonio.sanchez]

@nminchin

(you updated the screenshot) If so, you have your answer, you’re passing in 00:00:00 into the insert

Are you sure this shouldn’t be TimeDiff instead of MemTimeDiff?

I get the same result with either one

[antonio.sanchez]

I think I already found it was an error in the condition of the TAG “MemTimeDiff” and the value of the TAG “Falla Linea Disco”

Thank you so much