User default timezone (SQL)

aburkh — Thu, 12 Dec 2024 09:56:11 GMT

Users get confused when querying data with timestamps because UTC is not intuitive for many. It is possible to set TIME ZONE at query level or at SQL Warehouse level, but those options fail to address the need of multiple users working on the same warehouse in different timezones.

Would it be possible to set user-level time zone preferences, that would apply to all their SQL queries?

Re: User default timezone (SQL)

Alberto_Umana — Thu, 12 Dec 2024 13:06:11 GMT

it is possible to set the time zone at the session level using the SET TIME ZONE statement in Databricks SQL. This allows users to control the local timezone used for timestamp operations within their session. However, there is no direct option of user-level time zone preferences that would apply to all their SQL queries across different sessions.

Here are the relevant details:

Session-Level Time Zone Setting: You can set the time zone for a session using the SET TIME ZONE statement. This setting will apply to all timestamp operations within that session.

Example:

SET TIME ZONE = 'America/Los_Angeles';

SELECT current_timezone(); -- Returns 'America/Los_Angeles'

You can review this: https://docs.databricks.com/en/sql/language-manual/parameters/timezone.html

topic Re: User default timezone (SQL) in Warehousing & Analytics

User default timezone (SQL)

Re: User default timezone (SQL)