Datediff

Calculates the difference between two date, time, or timestamp expressions based on the date or time part requested. Difference is calculated as date_1 - date_2.

Parameters

Name	Type	Description	Is Optional
date_part	date_part	Must be one of the values listed in Supported Date and Time Parts
date_1	mixed_value	Starting date. Can be a date column, date, time, or timestamp.
date_2	mixed_value	Date to subtract from date_1. Can be a date column, date, time, or timestamp.
alias	value	Name for the new column created by the datediff.	True

Name

Type

Description

Is Optional

date_part

Must be one of the values listed in Supported Date and Time Parts

date_1

mixed_value

Starting date. Can be a date column, date, time, or timestamp.

date_2

mixed_value

Date to subtract from date_1. Can be a date column, date, time, or timestamp.

alias

value

Name for the new column created by the datediff.

True

Example

ds = rasgo.get.dataset(id)

ds2 = ds.datediff(date_part='year', date_1='END_DATE', date_2="'2022-01-01'")
ds2.preview()

Source Code

PreviousDateadd NextDatepart

Last updated 2 years ago