Menu

#349 DB2 Compatibility. CURRENT_TIMEZONE function

open-fixed
DB2 (1)
5
2024-04-20
2019-03-15
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

    Fred Toussi - 2022-07-28
    • status: open --> open-later
    • assigned_to: Fred Toussi
     
  • Fred Toussi

    Fred Toussi - 2024-04-20
    • status: open-later --> open-fixed
     
  • Fred Toussi

    Fred Toussi - 2024-04-20

    CURRENT_TIMEZONE will be added in version 2.7.3

     

Log in to post a comment.

MongoDB Logo MongoDB