My Oracle Support Banner

TO_DATETIME Function Issue In Datasets With MySQL As Datasource In Oracle Analytics (Doc ID 2941197.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud - Version September 2022 (6.8) and later
Information in this document applies to any platform.

Symptoms

When using the TO_DATETIME function on a date column coming from MySQL datasource in a dataset as below, the data shows 'Missing or Null' for the column.

The expression used is: TO_DATETIME(Col1, 'dd/mm/yyyy hh:mi:ss ap') where Col1 is of text/varchar datatype and converted to DATETIME using the 'Convert to Date' option in the dataset column options.

This issue is not observed in Oracle Databases.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.