Skip to main content
Version: 0.35.7


Convert lets you take an interval column and convert it to a different interval type.


Convert uses a single format: Convert the interval column <column> to <interval type>.


Convert uses the following parameters:

  • column (required). The interval column to convert.
  • interval type (required). The type of interval to convert to. The options include:
    • Days
    • Hours
    • Minutes
    • Months
    • Seconds
    • Weeks
    • Years


If the conversion is successful, a new column with the converted value is prepended to the dataset and a success message appears in the log.

Otherwise, an error message appears in the log.


To convert an interval column called "Duration" from minutes to days, enter Convert the interval column Duration to days.