DB2 Compatibility. CURRENT_TIMEZONE function

Relational Database

Brought to you by: fredt, unsaved

#349 DB2 Compatibility. CURRENT_TIMEZONE function

Milestone: Next Release (example)

Status: open-fixed

Owner: Fred Toussi

Labels: DB2 (1)

Priority: 5

Updated: 2024-04-20

Created: 2019-03-15

Creator: Oleksii Deordytsia

Private: No

Error during the execution DB2 SQL statement:
INSERT INTO HISTORY (FILE_NAME, DOMAIN, UPLOAD_DATE) VALUES ('someName', 'test', CURRENT_TIMESTAMP - CURRENT_TIMEZONE)

java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CURRENT_TIMEZONE

Environment:
jdbcUrl = jdbc:hsqldb:mem:testdb;DB_CLOSE_DELAY=-1;sql.syntax_db2=true
hsqldb version = 2.4.1

Discussion

Fred Toussi - 2022-07-28

status: open --> open-later

assigned_to: Fred Toussi
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Fred Toussi - 2024-04-20

status: open-later --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Fred Toussi - 2024-04-20

CURRENT_TIMEZONE will be added in version 2.7.3

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

DB2 Compatibility. CURRENT_TIMEZONE function

Relational Database

Group

Searches

Help

#349 DB2 Compatibility. CURRENT_TIMEZONE function

Discussion