{"id":1027,"date":"2007-12-07T13:27:54","date_gmt":"2007-12-07T21:27:54","guid":{"rendered":"http:\/\/cephas.net\/blog\/2007\/12\/07\/dates-milliseconds-java-and-firebug\/"},"modified":"2007-12-07T13:27:54","modified_gmt":"2007-12-07T21:27:54","slug":"dates-milliseconds-java-and-firebug","status":"publish","type":"post","link":"https:\/\/cephas.net\/blog\/2007\/12\/07\/dates-milliseconds-java-and-firebug\/","title":{"rendered":"Dates, Milliseconds, Java and Firebug"},"content":{"rendered":"

In Clearspace we store dates using their millisecond representation rather than as a full fledged date in database tables because we don’t want to have to worry about how each database represents dates, but that means that whenever you’re looking at a Clearspace database table, you see values like this:<\/p>\n

1172822399000<\/pre>\n
instead of something like this:<\/p>\n
2007-03-01 23:59:59.000<\/pre>\n
which makes debugging dates a little harder. Firebug and JavaScript to the rescue!  Open Firebug, click into the console area and then type this:<\/p>\n
new Date(1172822399000);<\/pre>\n
and then click ‘run’ and voila. You’ve got the date.  Have I told you how much I love Firebug<\/a>?<\/p>\n","protected":false},"excerpt":{"rendered":"
In Clearspace we store dates using their millisecond representation rather than as a full fledged date in database tables because we don’t want to have to worry about how each database represents dates, but that means that whenever you’re looking at a Clearspace database table, you see values like this: 1172822399000 instead of something like … Continue reading Dates, Milliseconds, Java and Firebug<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[29,33],"tags":[],"_links":{"self":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts\/1027"}],"collection":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/comments?post=1027"}],"version-history":[{"count":0,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts\/1027\/revisions"}],"wp:attachment":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/media?parent=1027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/categories?post=1027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/tags?post=1027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}