Localised Date Conversion

Aleksander Miler

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Exarto Sp. z o.o.

Description (Required):

There are many cases where imported data set has date formatted using month name in English(e.g. in CSV) and there is need to convert it do date or date time format during data import / dataset preparation. Unfortunately data conversion is based on the client language setting (e.g. polish) and if one wants to convert English named months into date it uses other language (e.g polish) months names and conversion is not possible. It cannot be applied to the date format other then OAC language set.

Use Case and Business Need (Required):

We tried to prepare demo for Media Company where some sample data we received were in CSV format using MMM dd, yyyy format for the date field. Unfortunately we could not quickly do date conversion because our OAC / OAC desktop language setting has not been compatible with language used in CSV for date time.

Enhancement Request / Service Request:

Please add option to select source language for data time conversion (important esp. when source date column has month names - short or long month names)

Bret Grinslade - Oracle Analytics-Oracle

We will take a look at this. We should provide a solution to this.