Families and the front desk in SQLite version 3.33 timestamp and time value analysis method-CodePudding

Home > database > Families and the front desk in SQLite version 3.33 timestamp and time value analysis method

Families and the front desk in SQLite version 3.33 timestamp and time value analysis method

Time：02-26

Pictured above question two points:
A. Xf_txdate for timestamp type, I use the SQL statement: the update xf_transdata set xf_txdate=CURRENT_TIMESTAMP where id='001',
Get the 2021-02-25 06:49:55 ,
How to get the figure shows: [the 2021-02-25 00:00:00. 000000]

2. Xf_txtime character types, how to solve this kind of character type is converted into time? Such as: the 113432 become time format, what are the rules?

Page link：https//www.codepudding.com/database/102589.html

Prev:SQL server2005 after open, "the object explorer" display database, security, etc

Next:Neural network model

Tags：

problems

Links：
CodePudding