Negative TIME

energiesysteme posted 7 years ago in Feature discussion

I've a TIME field which can contain negative values.
With the grid, I didn't find how enter a negative time (ie : -15:45:00).
If I use a SQL instruction, I can see the value in the grid, but I can't put it directly through the grid.
Is there any method to do that?

ansgar posted 7 years ago
As far as I can remember I never stored negative time values - so that's very new to me (but that's totally unimportant here) Reading the MySQL manual I found out that this is possible. So, yes, the grid editor does not allow that, and also does not allow to insert hours > 24. Should probably be fixed, while I think that's a rare case, don't you?
energiesysteme posted 7 years ago
I agree with you, it's quiet rare.
If you have to store time subtraction, you can have negative values. You can also have time greater than 24h.
It's not a bug, but if you have time, it would be more simple if the grid allows that.

Thx once again
ansgar posted 7 years ago
See issue #2203

Please login to leave a reply, or register at first.