Skip to main content

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 conversation history.

Otherwise, an error message appears.

Examples​

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