Confusing Display of Dates in Database View

Hi there,

In my day to day operations for my app, it is critical that my data is saved in UTC, which it is currently doing.

However while doing a query based on dates recently, I was missing some data, and while investigating the dates in my Xano database I got very confused thinking my dates where incorrectly being stored in Xano, but it turns out it was right all along.

I'm in Sydney, Australia so time here is UTC+11

However when looking at my database it shows it like this

When reading this I feel, one would infer that it's a GMT/UTC time + (timezone hours)

But it actually is converting it to my local time and also showing the + timezone hours. Which kinda doesn't make sense. Either show the +timezone hours (and UTC for the rest) or hide the +timezone hours completely.

My preference is it for the dates to show UTC time + local timezone hours

What do you think?

Other
3 replies