Date columns, timezone issue on a Postgres instance
Hey team, I am facing issues with columns with date type on tables of a Postgres instance deployed on railway.
I have a few columns defined with type
timestamps WITHOUT timezone
.
When I check the values from, for instancePGAdmin, the dates are correct (UTC, no timezone as expected).
However, when I check from the railway dashboard, I have 2 issues:
1. First of all, the dates are always displayed in my current timezone (see screenshot)
2. Secondly, if I edit a row and save it from the dashboard, the date field will be saved taking into account my current timezone.
Any idea how to solve those issues ?14 Replies
Project ID:
N/A
dont use the data tab, its will only cause issues
Thanks for your reply
Any reason behind this?
Also, is there any way to hide the data column from the dashboard then?
well i think you’ve outlined two great reasons 🤣
no way to hide, but you can disable it from having access to your database if that works for you?
Ahah true!
Bbut I meant, how come this issue occurs lol
its using localized time instead of utc
Ok ok got it
Thanks a lot for the reply
So in conclusion, I will just stop using the data tab and use a different client instead (even if it's quite sad cause the dashboard makes it super user freindly but nvm)
i know its unfortunate, would be really cool if it could work perfectly but the team doesn’t have the time to devote to the data tab
Sorry one last question, is there any way to make the DATA tab readonly?
nope, all you can do is disable dashboard access
I am not sure I get it.
When you say "disable dashboard access".
My database was created directly from railway dashboard and is* hosted within railway.
The "disable dashboard access" option is only for DB hosted out of railway is my understanding correct?
just remove one of these variables that you arent using
Aaa nice
got it
that's what I wanted thanks a lot
The UI is so great I would* be tempted to check the data directly from the UI
Now it's disabled so that's perfect
thanks a lot!
no problem!