Hi all,
Closely related to this topic:
I want to be able to display a MySQL "Time" column in a Power Table, but it is not working properly.
The query returns the following for TimeRemaining when running it in a query execution tool:
But returns something quite different in the power table:
I have used the following column formatting which I thought was reasonable for such a request.
I believe the issue is that the red rows have a negative time value, ie: -ve 2hrs 37min.
Which is then wrapping around 24hr time to be 22:37
Is there any other way to sort this out so it remains negative?
Non-negative times appear to display correctly.
NOTE: I can get it to work by casting as a string like suggested in the linked topic, but I'm interested to know why this isn't working as a datetime.