命令行
世界时间
create table t1( id integer primary key, node_addr int, channel_id int, value int, date timestamp not null default CURRENT_TIMESTAMP)
本地时间
create table t1( id integer primary key, node_addr int, channel_id int, value int, date timestamp not null default (datetime('now','localtime')))
参考
https://blog.csdn.net/waixingrenabc/article/details/44491549