github-actions[bot] commented on issue #13914: URL: https://github.com/apache/dolphinscheduler/issues/13914#issuecomment-1504577160
### 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 I am using version 3.1.4. When creating a sql task, I want to get the maximum date in the table, but the obtained date will be one day less: Success set taskVarPool: [{"prop":"etl_date","direct":"OUT","type":"VARCHAR","value":"2023-04-11"}] [INFO] 2023-04-12 03:45:37.132 +0000 - Full sql parameters: SqlParameters{type='MYSQL', datasource=9, sql='select max(etl_date) etl_date from ods.ods_population_sys_person_info', sqlType=0 , sendEmail=null, displayRows=10, limit=0, segmentSeparator=, udfs='null', showType='null', connParams='null', groupId='0', title='null', preStatements=[] , postStatements=[]} [INFO] 2023-04-12 03:45:37.132 +0000 - sql type : MYSQL, datasource : 9, sql : select max(etl_date) etl_date from ods.ods_population_sys_person_info , localParams : [Property{prop='etl_date', direct =OUT, type=VARCHAR, value=''}],udfs : null,showType : null,connParams : null,varPool : [Property{prop='etl_date', direct=OUT, type=VARCHAR, value='2023- 04-11'}] ,query max result limit 0 [INFO] 2023-04-12 03:45:37.132 +0000 - after replace sql , preparing : select max(etl_date) etl_date from ods.ods_population_sys_person_info [INFO] 2023-04-12 03:45:37.133 +0000 - Sql Params are replaced sql , parameters: [INFO] 2023-04-12 03:45:37.133 +0000 - can't find udf function resource [INFO] 2023-04-12 03:45:37.135 +0000 - prepare statement replace sql : select max(etl_date) etl_date from ods.ods_population_sys_person_info, sql parameters : {} [INFO] 2023-04-12 03:45:37.193 +0000 - display sql result 1 rows as follows: [INFO] 2023-04-12 03:45:37.193 +0000 - row 1 : {"etl_date":"2023-04-10"} [INFO] 2023-04-12 03:45:37.195 +0000 - Send task execute result to master, the current task status: TaskExecutionStatus{code=7, desc='success'} The query in the database is:  ### What you expected to happen Please see the time printed in the log is 2023-04-10 But the time in the actual database should be 2023-04-11 ### How to reproduce You can test it by querying the maximum time in the sql task ### Anything else _No response_ ### Version 3.1.x ### Are you willing to submit PR? - [X] 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]
