First Commit to PR Open time is undefined

[Kamlesh72]

Description:

First Commit to PR Open time is 0 or null if the system timezone is other than UTC.

Steps to reproduce:

1. Open Dora metrics
2. Open Lead time for changes
3. Average LT breakdown -> Commit duration

Additional context

If the database timezone is other than UTC, the PullRequest created_at, updated_at, state_changed_at fields time is incorrect.

Due to this, first_commit_to_open becomes a negative value.

first_commit_to_open = pr.created_at - pr_commits[0].created_at

[Kamlesh72]

For example, the PR is merged at 2025-01-30 19:03:23 +05:30 but the postgres shows 2025-01-30 13:33:23 +05:30

This happens if the system date is in Non UTC format and running through manual installation.

If I run middleware using docker, it works properly because docker timezone by default is UTC.