Why does time (DATETIME DEFAULT CURRENT_TIMESTAMP) have a different value in Sqlite3?

Question

PHP

I am creating a table

$sql="CREATE TABLE logs (id INTEGER PRIMARY KEY AUTOINCREMENT, date DATETIME DEFAULT CURRENT_TIMESTAMP, log TEXT)";
$db->query($sql);

only the time in the date field is 3 hours earlier. As I understand it, he lives in a zero time zone, and I live in Moscow, despite the fact that the server is also in Moscow and php returns Moscow time. Tell me, how can I set the correct time zone for sqlite3 in php?

Answer 1

This is how CURRENT_TIMESTAMP works - always in GMT.
Try something likeDEFAULT (datetime('now','localtime'))