Spark SQL - Get Current Timezone

Kontext Kontext visibility 3,426 event 2022-06-16 access_time 2 years ago language English

Spark SQL adds a new function named current_timezone since version 3.1.0 to return the current session local timezone.  Timezone can be used to convert UTC timestamp to a timestamp in a specific time zone. 

Code snippet

spark-sql> SELECT current_timezone();

Time zone can be used with other Spark functions like from_utc_timestamp which converts a UTC timestamp to a particular timestamp in a specified time zone.

spark-sql> SELECT from_utc_timestamp('2022-06-16', current_timezone());
2022-06-16 10:00:00
More from Kontext
copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts