interval

In [ ]:
interval(expr)

Converts the input value to a INTERVAL data type.

Parameters

Name Type Optional Description
expr
object
❌
 Expression.

Returns

str_sql : SQL expression.

Example

In [85]:
from verticapy import *
df = tablesample({"x": ['1 day', '2 hours']}).to_vdf()
display(df)
Abc
x
Varchar(7)
11 day
22 hours
Rows: 1-2 | Column: x | Type: varchar(7)
In [86]:
# Importing the stats module
import verticapy.stats as st

# Applying the interval function
df["interval_x"] = st.interval(df["x"])
display(df)
Abc
x
Varchar(7)
📅
interval_x
Interval
11 dayb'1'
22 hoursb'02:00'
Rows: 1-2 | Columns: 2