2 months ago
Issue:
- Database timezone: Asia/Tokyo (JST, UTC+9)
- Data stored in database: Correct JST times
- Railway GUI display: Shows UTC times (9 hours behind JST)
Example:
- Actual data in DB: 2025-01-15 09:00:00 (JST)
- Railway GUI shows: 2025-01-15 00:00:00 (UTC)
This makes it difficult to verify data directly in the Railway dashboard without manual timezone conversion.
Suggested improvement:
- Display times in the database's configured timezone, OR
- Add a timezone indicator (e.g., "UTC" or "JST") to column headers
Current workaround:
Manually add 9 hours when viewing times in the GUI.
2 Replies
2 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
2 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 2 months ago
2 months ago
I have a similar issue and the log show a discrepency on either how Railway calculate or how i use the timezone:
I used some debug lines and the server display wring data -
{ "id": 207, "created_at": "2025-10-03T02:28:22.232Z", "montreal_time": "2025-10-03T06:28:22.232Z", "montreal_date": "2025-10-03T00:00:00.000Z", "server_date": "2025-10-03T00:00:00.000Z", "montreal_current_date": "2025-10-03T00:00:00.000Z" },
Montreal should be -4
I used this in My SQL to find out :
console.log('DEBUG - Timezone:', timezone); console.log('DEBUG - Server current date:', new Date().toISOString()); console.log('DEBUG - Sessions returned:', rows.length); if (rows.length > 0) { rows.forEach(row => { console.log Session ${row.session_id}: created_at = ${row.created_at}); }); }
But i don't know how to fix it at the moment i use : AND DATE(ts.created_at - INTERVAL '4 hours') = DATE(CURRENT_TIMESTAMP - INTERVAL '4 hours') which bypass the timezone but don't want to hard code it all.
Hope this help and someone will help me find the fix