javascript - The value when sqlite saves the timestamp and then retrieves it is wrong

Question

Saved code

Value in sqlite

The value obtained by the front end

The data type stored in sqlite has been tried. Int date datetime is like this. When text is saved, it is taken out.

#What is the problem...

Answer 1

Obviously it’s a backend (server) problem. It’s possible that sqlite does not support millisecond-level timestamps

You need to divide the result by 1000 and ignore the decimal part