caishunfeng opened a new issue, #10076: URL: https://github.com/apache/dolphinscheduler/issues/10076
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues. ### What happened Token expire when different timezone between server and database, because I found the sql use database timestamp. ``` <select id="queryUserByToken" resultType="org.apache.dolphinscheduler.dao.entity.User"> select <include refid="baseSqlV2"> <property name="alias" value="u"/> </include> from t_ds_user u ,t_ds_access_token t where u.id = t.user_id and token=#{token} and t.expire_time > NOW() </select> ``` It's better to use server timestamp. ### What you expected to happen The token is normal when the expiration time has not expired ### How to reproduce 1. database use default timezone like CST 2. ds api server timezone use Asia/Shanghai 3. then create a token, just hour + 1 than current time. ### Anything else _No response_ ### Version dev ### 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](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
