Convert

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

Format

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

Parameters

Convert uses the following parameters:

• column. The interval column to convert.
• interval type. 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 chat history.

Otherwise, an error message appears in the chat history.

Examples

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