date_part

Extracts a part of the date/timestamp or interval source.

Syntax

Python

from pyspark.databricks.sql import functions as dbf

dbf.date_part(field=<field>, source=<source>)

Parameters

Parameter	Type	Description
field	pyspark.sql.Column	Selects which part of the source should be extracted, and supported string values are as same as the fields of the equivalent function extract.
source	pyspark.sql.Column or str	A date/timestamp or interval column from where field should be extracted.

Returns

pyspark.sql.Column: a part of the date/timestamp or interval source.

Examples

Python

import datetime
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(datetime.datetime(2015, 4, 8, 13, 8, 15),)], ['ts'])
df.select(
'*',
dbf.date_part(dbf.lit('YEAR'), 'ts').alias('year'),
dbf.date_part(dbf.lit('month'), 'ts').alias('month'),
dbf.date_part(dbf.lit('WEEK'), 'ts').alias('week'),
dbf.date_part(dbf.lit('D'), df.ts).alias('day'),
dbf.date_part(dbf.lit('M'), df.ts).alias('minute'),
dbf.date_part(dbf.lit('S'), df.ts).alias('second')
).show()