Search code examples
datetimepysparkdatabricks

Databricks pySpark datetime


I'm not sure why my datatime is being printed the way it is. I'm expecting the format of "%Y-%M-%D" (2020-05-11)

import datetime
from pyspark.sql.functions import *

currentdate = datetime.datetime.now().strftime("%Y-%M-%D")
print(dateValue)

Output: 
2020-09-05/11/20

Solution

  • Try with %Y-%m-%d instead of %Y-%M-%D

    currentdate = datetime.now().strftime("%Y-%m-%d")    
    print (currentdate)
    #2020-05-11
    
    #or using spark sql
    currentdate=spark.sql("select string(current_date)").collect()[0][0]
    print(currentdate)
    #2020-05-11