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/rasgotransforms/rasgotransforms/transforms/datediff/snowflake/datediff.sql at main · rasgointelligence/RasgoTransformsGitHub