By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
id INT,
dt DATETIME DEFAULT CURRENT_TIMESTAMP,
udt DATETIME DEFAULT (UTC_TIMESTAMP())
);
SET SESSION time_zone = '+00:00';
INSERT INTO test (id) VALUES (1);
SET SESSION time_zone = '+06:00';
INSERT INTO test (id) VALUES (2);
SELECT * FROM test;
| id | dt | udt |
|---|---|---|
| 1 | 2025-02-03 08:23:55 | 2025-02-03 08:23:55 |
| 2 | 2025-02-03 14:23:55 | 2025-02-03 08:23:55 |