[h2] Re: Revisiting manipulating CURRENT_TIMESTAMP

2022-07-28 Thread Silvio
Sorry for the late response, I was down with Covid. That makes sense, thanks! I would have to look into user defined functions but as long as they can make use of connection-specific state (the normal CURRENT_TIMESTAMP would have to be used simultaneously on all connections except the one perfo

[h2] Re: Revisiting manipulating CURRENT_TIMESTAMP

2022-07-21 Thread Evgenij Ryazanov
Hello! You can only add ;BUILTIN_ALIAS_OVERRIDE=TRUE to JDBC URL and create an own user-defined function with that name (CREATE ALIAS "CURRENT_TIMESTAMP" …): https://h2database.com/html/commands.html#create_alias But usually it is better to move that logic from database level to Java persistenc