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 ?
No description
14 Replies
Percy
Percy12mo ago
Project ID: N/A
Brody
Brody12mo ago
dont use the data tab, its will only cause issues
Hugo Tessera
Hugo Tessera12mo ago
Thanks for your reply Any reason behind this? Also, is there any way to hide the data column from the dashboard then?
Brody
Brody12mo ago
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?
Hugo Tessera
Hugo Tessera12mo ago
Ahah true! Bbut I meant, how come this issue occurs lol
Brody
Brody12mo ago
its using localized time instead of utc
Hugo Tessera
Hugo Tessera12mo ago
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)
Brody
Brody12mo ago
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
Hugo Tessera
Hugo Tessera12mo ago
Sorry one last question, is there any way to make the DATA tab readonly?
Brody
Brody12mo ago
nope, all you can do is disable dashboard access
No description
Hugo Tessera
Hugo Tessera12mo ago
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?
Brody
Brody12mo ago
just remove one of these variables that you arent using
Hugo Tessera
Hugo Tessera12mo ago
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!
Brody
Brody12mo ago
no problem!
Want results from more Discord servers?
Add your server