Negative TIME

[expired user #4726]'s profile image [expired user #4726] posted 14 years ago in Feature discussion Permalink
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
ansgar's profile image ansgar posted 14 years ago Permalink
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?
[expired user #4726]'s profile image [expired user #4726] posted 14 years ago Permalink
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's profile image ansgar posted 13 years ago Permalink
See issue #2203

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