LOCALTIMESTAMP returns the wrong data type
Details
| Detail name | Value |
|---|---|
| Changelog Number | 20241 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
| Fix Versions | Exasol 8.32.0 |
| Resolution Date | 2024-11-08 |
Description
The return value of the function LOCALTIMESTAMP has the data type TIMESTAMP WITH LOCAL TIME ZONE instead of the expected data type TIMESTAMP.
Workaround
Use CAST(LOCALTIMESTAMP AS TIMESTAMP) to fix the return type.
Fix
The return value of LOCALTIMESTAMP now has the data type TIMESTAMP. Please notice that CURRENT_TIMESTAMP can be used if the data type TIMESTAMP WITH LOCAL TIME ZONE is intended.
Changed behavior
The return value of LOCALTIMESTAMP now conforms to the SQL Standard and has the data type TIMESTAMP.
