โ12-22-2022 11:35 PM
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
โ12-23-2022 12:19 AM
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
โ12-22-2022 11:36 PM
@Pat Sienkiewiczโ , @Hubert Dudekโ please guide me here
โ12-23-2022 12:19 AM
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
โ12-23-2022 12:29 AM
@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
โ12-23-2022 08:51 AM
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.
โ12-23-2022 02:10 AM
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.
โ12-23-2022 04:54 AM
I got it guys it was happening due to a library conflict now your answers are really helpful I tried all things
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.