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?
  • Related