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, open a dataset or workbook.
   • Hover over the dataset, click Actions (), and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
   • Hover over the workbook that contains the dataset, click Actions (), then select Open, then click Data. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.

   Note:

   Oracle Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
2. Hover over the column that you want to convert.
3. Click
   
   

   
   Description of the illustration column-options-menu.png

   
   
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.