[SQLite] Getting Current Time in Japan Standard Time (JST) with datetime
Tadashi Shigeoka · Fri, December 9, 2011
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.