Date / time isn't represented accurately on the frontend when using postgres

[NeurekaSoftware]

Description

Date / time isn't represented accurately on the frontend when using postgres

Version

2.5.2

Steps to Reproduce

1. Do anything that creates a datetime in the database (postgres only)
2. See that the datetime is not displayed correctly on the frontend.

Screenshots

Logs

Platform

desktop

Database

PostgreSQL

Device

Desktop

Operating System

Windows 11 Pro

Browser

Edge

Additional Context

No response

Code of Conduct

• I agree to follow Jellyseerr's Code of Conduct

[fallenbagel]

This is not a bug that is limited to issues. It only happens with postgresql because of the without timezone handling in db while not factoring that in when displaying. This issue is not there for sqlite. This issue is present everywhere that a created date is used from the db.

Would you mind editing this bug report to talk about that and not just issues? As this is not a bug with issues per se but postgresql?

[NeurekaSoftware]

Would you mind editing this bug report to talk about that and not just issues?

@fallenbagel does that look better?

Thank you for the quick response.

[NeurekaSoftware]

Do we know if this will be addressed soon? Issues are really broken because of this. 😭

[fallenbagel]

Do we know if this will be addressed soon? Issues are really broken because of this. 😭

Yes. This fix will be available for next version.

[NeurekaSoftware]

Do we know if this will be addressed soon? Issues are really broken because of this. 😭

Yes. This fix will be available for next version.

Awesome!!! Thank you!