Skip to main content
Version: 0.35.7

Convert

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

Format

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

Parameters

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

Output

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.

Examples

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