To get the current time in Japan Standard Time (JST) with SQLite, you can specify localtime as the second argument to datetime.

select datetime('now', 'localtime') as datetime_jp;

That’s all from the Gemba.

Reference Information

• SQLiteのTIMESTAMP型のフィールド値をSQLiteのdatetime関数で日本時間に変換 - CLの日記