Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

Invalid Date/Time Format Model FF0

Details

Detail name	Value
Changelog Number	13672
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0
Fix Versions	Exasol 8.2.0
Resolution Date	2022-08-12

Background

Exasol supports specifying date/time format models. These include FF1 through FF9 to specify the fraction of a second in a timestamp.

Description

The database erroneously allowed the date/time format FF0, which is invalid.

Workaround

Use ALTER SESSION or ALTER SYSTEM to remove FF0 from the NLS_TIMESTAMP_FORMAT setting.

Fix

FF0 is no longer allowed and causes a "data exception - invalid datetime format".

Changed behavior

FF0 is no longer allowed and causes a "data exception - invalid datetime format".