topic Re: Time Parameter Returns Incorrect Time in Data Engineering

Time Parameter Returns Incorrect Time

Anonymous — Fri, 28 Oct 2022 23:55:28 GMT

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

Re: Time Parameter Returns Incorrect Time

User16753725469 — Sun, 27 Nov 2022 19:46:57 GMT

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

Re: Time Parameter Returns Incorrect Time

Anonymous — Mon, 09 Jan 2023 05:14:06 GMT

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!