[Bug][ZenTao] date filed does not take into account the time zone where zentao is located

[xiaomingzhang12]

Search before asking

• [X] I had searched in the issues and found no similar issues.

What happened

Take the 6115 bug as an example, 2023-09-04 closed the issue at 11:57:14, collected the data, and view issue_changelogs the table, the corresponding create_date is 2023-09-04 19:57:14 + 08 The zentao time zone of the testing environment is Beijing UTC + 8

What do you expect to happen

The corresponding create_date is 2023-09-04 11:57:14 + 08 From linwei: The standard process should be to combine this string (or datetime type) + the time zone where zentao is located, and then convert these two information into the time in the UTC time zone.

How to reproduce

See “What happened”

Anything else

No response

Version

v0.18

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[d4x1]

I think it is related with the db url config. please provide some additional information.

[xiaomingzhang12]

Devlake doesn't need to be changed. When filling in zentao dburl on ee side, just add loc = Asia/Shanghai.