
Sqlite direct query: Select a datetime (' now ', 'a localtime)

Table structure:

After inserting data automatically update time:

Now meet a problem, the database automatically update the modification time is wrong, the world is poor TianYuan, I query the system time, time also query sqlite area, are correct the current time, why is automatically set time type to a datetime (' now ', 'a localtime) like this, consult your bosses
CodePudding user response:
