snowflake.snowpark.functions.make_interval¶

snowflake.snowpark.functions.make_interval(years: Optional[int] = None, quarters: Optional[int] = None, months: Optional[int] = None, weeks: Optional[int] = None, days: Optional[int] = None, hours: Optional[int] = None, minutes: Optional[int] = None, seconds: Optional[int] = None, milliseconds: Optional[int] = None, microseconds: Optional[int] = None, nanoseconds: Optional[int] = None, mins: Optional[int] = None, secs: Optional[int] = None) → Column[source]¶

Creates an interval column with the specified years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds, and nanoseconds. You can find more details in Interval constants.

INTERVAL is not a data type (that is, you can’t define a table column to be of data type INTERVAL). Intervals can only be used in date, time, and timestamp arithmetic. For example, df.select(make_interval(days=0)) is not valid.

Example:

>>> import datetime
>>> from snowflake.snowpark.functions import to_date
>>>
>>> df = session.create_dataframe([datetime.datetime(2023, 8, 8, 1, 2, 3)], schema=["ts"])
>>> df.select(to_date(col("ts") + make_interval(days=10)).alias("next_day")).show()
--------------
|"NEXT_DAY"  |
--------------
|2023-08-18  |
--------------
Copy

You can also find some examples to use interval constants with range_between() method.

Language: English