xuzifu666 commented on PR #23754: URL: https://github.com/apache/flink/pull/23754#issuecomment-1818468102
> > if user want to use many timezone in one sql with TO_TIMESTAMP，they can not choose timezone for it. > > CONVERT_TZ(‘2012-10-31 01:00’, ‘UTC’, ‘America/Los_Angeles’) > > Would return > > 2012-10-30 18:00:00.000 > > So why wouldn't it be possible? > > > Add the timezone arguments can aviod it and not bring any risk. > > From my point of view, we're mixing TIMESTAMP and TIMESTAMP_LTZ in one function and we shouldn't do that. emm, it is not a user sence. if time char need a format，CONVERT_TZ can not fit it，and some sence in a sql had many kinds of time string format@MartijnVisser -- 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: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
