distal-attribute
distal-attribute
distal-attribute
distal-attribute

Negative TIME

User, date Message
Written by energiesysteme
4 years ago
Category: Feature discussion
17 posts since Wed, 24 Feb 10
Hi,

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?

Thx
Written by ansgar
4 years ago
4988 posts since Fri, 07 Apr 06
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?
Written by energiesysteme
4 years ago
17 posts since Wed, 24 Feb 10
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
Written by ansgar
4 years ago
4988 posts since Fri, 07 Apr 06
See issue #2203
 

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