Timezone understanding

[Aviral-Bhardwaj]

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

[Aviral-Bhardwaj]

@Pat Sienkiewicz​ , @Hubert Dudek​  please guide me here

[Prabakar · Accepted solution]

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

[Aviral-Bhardwaj]

@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

[Hubert-Dudek]

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.

[daniel_sahal]

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.

[Aviral-Bhardwaj]

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