Hi @CN As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

--show diff values if hour is 02 select '2021-03-14 02:01:03.118', cast('2021-03-14 02:01:03.118' as timestamp) OUTPUT _c0 _c1 1 2021-03-14 02:01:03.118 2021-03-14 03:01:03.118 ... View more