1. User’s Guide for Oracle Analytics Desktop
  2. Enrich and Transform Data
  3. Convert Text Columns to Date or Time Columns

Convert Text Columns to Date or Time Columns

You can convert any text column to a date, time, or timestamp column.

For example, you can convert an attribute text column to a true date column.
  1. On the Home page, hover over a dataset that you own, click Actions, and then select Open.
    If the dataset contains a single table, you'll see the transform editor. If the dataset contains multiple tables, you'll see the Join Diagram. In the Join Diagram, right-click a data source and click Open to display the transform editor.
    Description of data-preparation-toggle-options.png follows
    Description of the illustration data-preparation-toggle-options.png

  2. Hover over the column that you want to convert.
  3. Click Options, (Options) in the column header.
  4. Select one of the conversion options, for example, Convert to Number, or Convert to Date.
    Oracle Analytics adds a step to the Preparation Script panel.
  5. To save your data preparation changes and apply them to your data, click Save Dataset.
    The changes you make apply to all workbooks using that data source.