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
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
RasgoTransforms/datediff.sql at main · rasgointelligence/RasgoTransforms
GitHub

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

Dateadd

Datepart

Last modified 1yr ago