Negative TIME
| User, date | Message |
|---|---|
|
Written by energiesysteme
3 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
3 years ago 3950 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
3 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
3 years ago 3950 posts since Fri, 07 Apr 06 |
See issue #2203 |
|
Please login to leave a reply, or register at first. |