[Feature][Server] Support custom timezone

[caishunfeng]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

• Unified config timezone by spring
  Now DS use the default timezone GMT+8, and add the @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") on date type field in many object, which is hard to unified timezone and change it.

• Support custom timeone
  The api interface return datetime is string type, which lose the timezone info, the same for api requests, so maybe it should supply customize timezone for user.

  • After discussion, we think it's better to add timezone into user info config, and user can select other timezone freely. If no timezone is specified, default use timezone UTC +0:00.
  • UI support user to change timezone, default local timezone.
  • Handler timezone unified in server

Task List

• [Feature][Server] Custom timezone - Unified config timezone by spring #8385
• [Feature][Server] Custom timezone - Add timezone into user info #8386
• [Feature][Server] Custom timezone - Add timezone handler unified #8479
• [Feature][UI] Custom timezone #8530

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

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

[github-actions]

Hi:

• Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
• In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
• If you haven't received a reply for a long time, you can subscribe to the developer's email，Mail subscription steps reference https://dolphinscheduler.apache.org/en-us/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.

[jim-parsons]

I think timezone is a non-hign-frequency property and it belongs application level so its not that necessary to customize it.
I check the code and some module like dolphinscheduler-api has the spring.jackson-timezone config.

[caishunfeng]

I think timezone is a non-hign-frequency property and it belongs application level so its not that necessary to customize it.

Now DS use GTM+8 as default and it's hard to use in other countries, so it's a very important feature for development in other countries.

I check the code and some module like dolphinscheduler-api has the spring.jackson-timezone config.

Yes, and the json format annotation should be remove, unified timezone by spring config.

[jim-parsons]

I think timezone is a non-hign-frequency property and it belongs application level so its not that necessary to customize it.

Now DS use GTM+8 as default and it's hard to use in other countries, so it's a very important feature for development in other countries.

I check the code and some module like dolphinscheduler-api has the spring.jackson-timezone config.

Yes, and the json format annotation should be remove, unified timezone by spring config.

got it. if the spring config solution is ok , assign it to me, thx~

[caishunfeng]

Hi @tangchunbo I had split the sub issue. If you are interested in, please tell me, thx~

[jim-parsons]

Hi @tangchunbo I had split the sub issue. If you are interested in, please tell me, thx~

ok, i‘ll do this issue. but i've got a question, how do l understand issue #8386 , add timezone into table t_ds_user ? plz help me out

[caishunfeng]

ok, i‘ll do this issue. but i've got a question, how do l understand issue #8386 , add timezone into table t_ds_user ? plz help me out
yes, add timezone field into table t_ds_user, and provides an interface to update timezone separately. what do you think? @tangchunbo

[jim-parsons]

ok, i'll do the these issues's(#8385 , #8386 ) backend work.