84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
1497154554827.0 This time is a timestamp returned by an API, which is a millisecond timestamp
How to convert to timestamp format in mysql
The transfer time on the time conversion website is 2017/6/11 12:15:54
Divide by 1000 and use date to convertecho date('Y-m-d H:i:s', 1497154554827.0 / 1000);
echo date('Y-m-d H:i:s', 1497154554827.0 / 1000);
I also tried this method and the result was 2017-06-11 06:15:54. It doesn’t match the poster’s 2017/6/11 12:15:54. I don’t know if the poster wrote it wrong.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Divide by 1000 and use date to convert
echo date('Y-m-d H:i:s', 1497154554827.0 / 1000);I also tried this method and the result was 2017-06-11 06:15:54. It doesn’t match the poster’s 2017/6/11 12:15:54. I don’t know if the poster wrote it wrong.