🟩 Your Way: Spring Boot sets timestamps

(using @CreatedDate and @LastModifiedDate)

@CreatedDate
private Instant createdAt;

@LastModifiedDate
private Instant updatedAt;

✅ What happens:

• Spring sets the time in Java, not in the database.
• You control it in code.
• Easy to test, change, or mock.
• Works exactly how you expect.

Correct Postgres Type:

    ALTER COLUMN stalk_date TYPE TIMESTAMP WITH TIME ZONE,
    ALTER COLUMN expiry_date TYPE TIMESTAMP WITH TIME ZONE,
    ALTER COLUMN created_at TYPE TIMESTAMP WITH TIME ZONE,
    ALTER COLUMN send_date TYPE TIMESTAMP WITH TIME ZONE,

🟨 The Other Way: Database sets timestamps

(using DEFAULT CURRENT_TIMESTAMP in SQL)

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

✅ What happens:

• Database sets the time automatically only on INSERT.
• Not updated again unless you use a trigger.
• You lose control from your Java code.