T4bsW2te

1CREATE TABLE IF NOT EXISTS TEST(
2  DATE timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3);
4	
5CREATE TABLE IF NOT EXISTS TEST(
6  DATE timestamp AS CURRENT_TIMESTAMP
7);
8	
9CREATE TRIGGER my_trigger
10  BEFORE UPDATE
11  ON my_table
12  FOR EACH ROW CALL "org.h2.trigger.UpdatedAtTrigger";
13	
14package org.h2.trigger;
15
16import java.sql.*;  
17import java.time.Instant;
18import org.h2.tools.TriggerAdapter;
19
20public class UpdatedAtTrigger extends TriggerAdapter {
21
22  @Override
23  public void fire(Connection conn, ResultSet oldRow, ResultSet newRow) throws SQLException {
24    newRow.updateTimestamp("updated_at", Timestamp.from(Instant.now()));
25  }
26}