Time Parameter Returns Incorrect Time

[Zach-dbMotion]

For some reason, the parameter keeps showing me my local time in UTC. When converting this parameter from EST, the offset is wrong. In the screenshot, you can see that my local session TZ is set to ETC/UTC (for whatever reason). It looks like the parameter is taking my OS clock time, and then appending the session TZ, creating a timestamp with an incorrect offset.

Please see the attachment as an example.

Can someone tell me how I am supposed to translate this so I can use it in a where clause? Is this a bug?

This happens when I test in Edge and Chrome. This behavior also occurs when I set our SQL endpoint to the preview channel v 2022.35

[User16753725469]

please refer: https://docs.databricks.com/sql/language-manual/sql-ref-syntax-aux-conf-mgmt-set-timezone.html

[Anonymous]

Hi @Zachary Higgins​ 

Hope everything is going great.

Does @Prasad Wagh​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?

We'd love to hear from you.

Thanks!