cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get today's date in the local time zone?

Mado
Valued Contributor II

I am trying to get today's date in the local time zone:

from pyspark.sql.functions import * 
date = to_date(from_utc_timestamp(current_timestamp(), 'Australia/Melbourne'))

What I get using the above code is a column object.

How can I get its value in a variable? I tried ".first()" but it doesn't work on the column object.

image 

1 ACCEPTED SOLUTION

Accepted Solutions

Hemant
Valued Contributor II

Hi @Mohammad Saber​ , you can use pytz and datetime python package for your usecase,, attaching code snippet in below screen shot.

Screenshot 2023-03-27 000020 

Hemant Soni

View solution in original post

1 REPLY 1

Hemant
Valued Contributor II

Hi @Mohammad Saber​ , you can use pytz and datetime python package for your usecase,, attaching code snippet in below screen shot.

Screenshot 2023-03-27 000020 

Hemant Soni
Welcome to Databricks Community: Lets learn, network and celebrate together

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.