How to change timestamp of SQLITE DB to local timestamp

Question

I insert a record into sqlite database a date by current_timestamp. The idea ist, NOT to set the time manually. Now, the thing is, that my date in the database is 5.30 hours after inserting. Any ideas, how to walk around or fix that?

Answer 1

use :

CREATE TABLE table 
( ... 
, yourColumnName DATETIME DEFAULT (DATETIME(CURRENT_TIMESTAMP, 'LOCALTIME'))
, ...
);