CallMeKingsley97 commented on issue #14632: URL: https://github.com/apache/dolphinscheduler/issues/14632#issuecomment-1651094657
> i use sql " SHOW GLOBAL VARIABLES LIKE 'time_zone' " to check mysql's timezone,the result is "system" No time zone configuration found in my.conf file Using the date +%Z command returns CST. > […](#) > ------------------ 原始邮件 ------------------ 发件人: ***@***.***>; 发送时间: 2023年7月26日(星期三) 上午9:03 收件人: ***@***.***>; 抄送: ***@***.***>; ***@***.***>; 主题: Re: [apache/dolphinscheduler] [Bug] [Process Instance] task_instance time and process_instance time is different (Issue #14632) SELECT u.id, u.start_time task_start_time,u.end_time as task_end_time, t.start_time process_start_time,t.end_time as process_end_time, t.name process_name, SUBSTRING(t.name, 17, 14) as prcoss_name_time from t_ds_task_instance u INNER JOIN t_ds_process_instance t on u.process_instance_id = t.id ORDER BY u.id desc SQL is right. Have you check your mysql's timezone? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>  In this website. [https://www.jb51.net/article/271660.htm](url). I think your timezone config is simliar to the screenshot. Maybe you can resolve your problem by using his solution. -- 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]
