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

Home > Back-end > 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/Backend/102650.html

Prev:Not loaded libTUIO. PDB

Next:C # to Delphi hai kang alarm callback function, really don't understand, c #,

Tags：

Database related

Links：
CodePudding