last_day

Returns the last day of the month which the given date belongs to.

For the corresponding Databricks SQL function, see last_day function.

Syntax

Python

from pyspark.databricks.sql import functions as dbf

dbf.last_day(date=<date>)

Parameters

Parameter	Type	Description
date	pyspark.sql.Column or str	target column to compute on.

Returns

pyspark.sql.Column: last day of the month.

Examples

Python

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('1997-02-10',)], ['dt'])
df.select('*', dbf.last_day(df.dt)).show()
df.select('*', dbf.last_day('dt')).show()