开发者

How is this date field encoded?

开发者 https://www.devze.com 2023-02-13 18:10 出处:网络
I am consuming an REST service that allows me to query a table in a database. There is a date field in that table, but the service is returning the date in a开发者_如何学编程 strange format, and I\'m

I am consuming an REST service that allows me to query a table in a database. There is a date field in that table, but the service is returning the date in a开发者_如何学编程 strange format, and I'm unsure how to parse it.

I know for a fact that a certain record's date is 2010/07/16 00:00:00 UTC, and the string that I get for the date is 1279238400000. How is this date being encoded? How to I get from that large number to July 7, 2010?


I think what you're having is milliseconds since 1970-01-01.


Looks to be a Javascript-style timestamp: milliseconds since Jan 1/1970:

mysql> select from_unixtime(1279238400000 / 1000);
+-------------------------------------+
| from_unixtime(1279238400000 / 1000) |
+-------------------------------------+
| 2010-07-15 18:00:00                 |
+-------------------------------------+
1 row in set (0.05 sec)

Giving 6pm, July 15th, 2010.

0

精彩评论

暂无评论...
验证码 换一张
取 消