topic Re: Timezone understanding in Data Engineering

Timezone understanding

Aviral-Bhardwaj — Fri, 23 Dec 2022 07:35:18 GMT

Today I was working in Timezone kind of data but my Singapore user want to see their time in the Data and USA user want to see their time in the data

instead of both, we all are getting UTC time,how to solve this issue

Please guide

Data can be anything but time should be there

Re: Timezone understanding

Aviral-Bhardwaj — Fri, 23 Dec 2022 07:36:38 GMT

@Pat Sienkiewicz , @Hubert Dudek please guide me here

Re: Timezone understanding

Prabakar — Fri, 23 Dec 2022 08:19:17 GMT

Hi @Aviral Bhardwaj have you tried setting the timezone?

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

Re: Timezone understanding

Aviral-Bhardwaj — Fri, 23 Dec 2022 08:29:24 GMT

@Prabakar Ammeappin you are always awesome but the thing is that I don't want to do this with my customer , I just want whenever they will query they will get their time zone ,without any query update

Re: Timezone understanding

daniel_sahal — Fri, 23 Dec 2022 10:10:23 GMT

I don't think that there's an easy way to switch the timezones when reading the data. Even if it was possible then it could cause some data inconsistency (ex. different date could be reported within different timezones).

If you really need that IMO you should create some custom views that shows the data with different timezones.

Re: Timezone understanding

Aviral-Bhardwaj — Fri, 23 Dec 2022 12:54:48 GMT

I got it guys it was happening due to a library conflict now your answers are really helpful I tried all things

Re: Timezone understanding

Hubert-Dudek — Fri, 23 Dec 2022 16:51:50 GMT

In SQL Admin Console, you can set a timezone parameter, but it will be for the whole workspace https://docs.databricks.com/sql/admin/sql-configuration-parameters.html.

Additionally, how your customer connects? It may be easier to do on a tool like PowerBI.