{"id":7165,"date":"2008-11-17T22:55:22","date_gmt":"2008-11-17T22:55:22","guid":{"rendered":"http:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/"},"modified":"2008-11-17T22:55:22","modified_gmt":"2008-11-17T22:55:22","slug":"unix-timestamp","status":"publish","type":"post","link":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/","title":{"rendered":"Unix Timestamp"},"content":{"rendered":"\u23f3 Approximate reading time: <\/span> 2<\/span> mins<\/span><\/span>

A quick entry: It’s getting late, and I teach in the morning, then spend two hours in the WC, and after that, a meeting. Plus, I just looked out the window, and it appears that we live in the snowy part of Syracuse, so chances are I’ll have to remember where I last took off my winter boots back when last it snowed in, what, May?<\/p>\n

This weekend I stumbled onto a few limitations for Movable Type and Delicious mash-ups I’d been thinking about for some time.<\/p>\n

I’d been plotting for a few weeks a plan to export all 1000-some entries from EWM into a standard bookmark format. After the export, I was going to upload the full index (complete with keywords, notes, and timestamps) to Delicious. Easy, yeah? I thought so. But the problem is that I can’t–yet–figure out how to get MT to output a date in epoch form (i.e., as a Unix timestamp). I even posted on the forums, and the question has had several views, but no answers. MT has a gob of other MTEntryDate output options, but no Unix timestamp.<\/p>\n

Without getting into the MySQL (and risking a terrible MesSQL), the most obvious workaround is to output the list of entries and such into a simple list that, with some “text to column” magic in Excel would allow me to select and copy the dates from a long string of entries, run them through a batch converter, paste the epoch-formatted numbers back into place, and switch the text into an editor. It might still require a few search and replace actions, but this process would get it close to the standard bookmark format–close enough that Delicious could import the list, anyway. And that’s the point to all of this.<\/p>\n

While I was messing around with this, I also learned that Delicious limits the earliest timestamps to 1989 or something. I guess this isn’t all that big of a deal, but it does introduce a problem if, say, we were ever to attempt to use Delicious with some sort of date-stamping method for chronologically ordering bookmarks for a journal archive dating back to the early 1980s.<\/p>\n

It’s good to know about these limitations, I suppose, well in advance of experimenting with them on a larger, more consequential project.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u23f3 Approximate reading time: <\/span> 2<\/span> mins<\/span><\/span>A quick entry: It’s getting late, and I teach in the morning, then spend two hours in the WC, and after that, a meeting. Plus, I just looked out the window, and it appears that we live in the snowy part of Syracuse, so chances are I’ll have to remember where I last took off…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[13],"tags":[2109,2110,709,1603,2111,2112,2113,305,2114,2115],"class_list":["post-7165","post","type-post","status-publish","format-standard","hentry","category-technologies","tag-bookmark","tag-date","tag-delicious","tag-epoch","tag-export","tag-format","tag-import","tag-movable-type","tag-timestamp","tag-unix"],"yoast_head":"\nUnix Timestamp - Earth Wide Moth<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unix Timestamp - Earth Wide Moth\" \/>\n<meta property=\"og:description\" content=\"\u23f3 Approximate reading time: 2 minsA quick entry: It’s getting late, and I teach in the morning, then spend two hours in the WC, and after that, a meeting. Plus, I just looked out the window, and it appears that we live in the snowy part of Syracuse, so chances are I’ll have to remember where I last took off...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/\" \/>\n<meta property=\"og:site_name\" content=\"Earth Wide Moth\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/derek.mueller\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/derek.mueller\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-17T22:55:22+00:00\" \/>\n<meta name=\"author\" content=\"Derek Mueller\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Derek Mueller\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/\"},\"author\":{\"name\":\"Derek Mueller\",\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\"},\"headline\":\"Unix Timestamp\",\"datePublished\":\"2008-11-17T22:55:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/\"},\"wordCount\":392,\"publisher\":{\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\"},\"keywords\":[\"bookmark\",\"date\",\"delicious\",\"epoch\",\"export\",\"format\",\"import\",\"Movable Type\",\"timestamp\",\"unix\"],\"articleSection\":[\"Technologies\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/\",\"url\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/\",\"name\":\"Unix Timestamp - Earth Wide Moth\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#website\"},\"datePublished\":\"2008-11-17T22:55:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/2008\\\/11\\\/17\\\/unix-timestamp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unix Timestamp\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#website\",\"url\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/\",\"name\":\"Earth Wide Moth\",\"description\":\"\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/#\\\/schema\\\/person\\\/66fc5e80a62f53057760790b1cfeb24b\",\"name\":\"Derek Mueller\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\",\"width\":1220,\"height\":480,\"caption\":\"Derek Mueller\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.earthwidemoth.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-bmartwork.png?fit=1220%2C480\"},\"sameAs\":[\"http:\\\/\\\/www.derekmueller.net\\\/\",\"https:\\\/\\\/www.facebook.com\\\/derek.mueller\",\"https:\\\/\\\/www.instagram.com\\\/dereknmueller\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dnmueller\"],\"url\":\"https:\\\/\\\/www.earthwidemoth.com\\\/blog\\\/author\\\/dmueller\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Unix Timestamp - Earth Wide Moth","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/","og_locale":"en_US","og_type":"article","og_title":"Unix Timestamp - Earth Wide Moth","og_description":"\u23f3 Approximate reading time: 2 minsA quick entry: It’s getting late, and I teach in the morning, then spend two hours in the WC, and after that, a meeting. Plus, I just looked out the window, and it appears that we live in the snowy part of Syracuse, so chances are I’ll have to remember where I last took off...","og_url":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/","og_site_name":"Earth Wide Moth","article_publisher":"https:\/\/www.facebook.com\/derek.mueller","article_author":"https:\/\/www.facebook.com\/derek.mueller","article_published_time":"2008-11-17T22:55:22+00:00","author":"Derek Mueller","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Derek Mueller","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/#article","isPartOf":{"@id":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/"},"author":{"name":"Derek Mueller","@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b"},"headline":"Unix Timestamp","datePublished":"2008-11-17T22:55:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/"},"wordCount":392,"publisher":{"@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b"},"keywords":["bookmark","date","delicious","epoch","export","format","import","Movable Type","timestamp","unix"],"articleSection":["Technologies"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/","url":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/","name":"Unix Timestamp - Earth Wide Moth","isPartOf":{"@id":"http:\/\/www.earthwidemoth.com\/blog\/#website"},"datePublished":"2008-11-17T22:55:22+00:00","breadcrumb":{"@id":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.earthwidemoth.com\/blog\/2008\/11\/17\/unix-timestamp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.earthwidemoth.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Unix Timestamp"}]},{"@type":"WebSite","@id":"http:\/\/www.earthwidemoth.com\/blog\/#website","url":"http:\/\/www.earthwidemoth.com\/blog\/","name":"Earth Wide Moth","description":"","publisher":{"@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.earthwidemoth.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/www.earthwidemoth.com\/blog\/#\/schema\/person\/66fc5e80a62f53057760790b1cfeb24b","name":"Derek Mueller","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480","url":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480","contentUrl":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480","width":1220,"height":480,"caption":"Derek Mueller"},"logo":{"@id":"https:\/\/i0.wp.com\/www.earthwidemoth.com\/blog\/wp-content\/uploads\/2023\/04\/cropped-bmartwork.png?fit=1220%2C480"},"sameAs":["http:\/\/www.derekmueller.net\/","https:\/\/www.facebook.com\/derek.mueller","https:\/\/www.instagram.com\/dereknmueller\/","https:\/\/www.youtube.com\/user\/dnmueller"],"url":"https:\/\/www.earthwidemoth.com\/blog\/author\/dmueller\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7tdGk-1Rz","jetpack-related-posts":[{"id":7499,"url":"https:\/\/www.earthwidemoth.com\/blog\/2016\/04\/21\/changeling\/","url_meta":{"origin":7165,"position":0},"title":"Changeling","author":"Derek Mueller","date":"April 21, 2016","format":false,"excerpt":"I spent the better part of today finally finally finally after years converting from Movable Type to Wordpress. I've run EWM on Movable Type since 2004, and the blog has in part as a result of its cumbersome platform dwindled, faded, crept quietly into an idle corner of the web.\u2026","rel":"","context":"In "On Weblogs"","block_context":{"text":"On Weblogs","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/on_weblogs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7291,"url":"https:\/\/www.earthwidemoth.com\/blog\/2010\/09\/27\/in-other-words\/","url_meta":{"origin":7165,"position":1},"title":"In Other Words, Hello","author":"Derek Mueller","date":"September 27, 2010","format":false,"excerpt":"I read with great interest last week's announcement from Ben and Mena Trott, co-founders of Six Apart, Ltd., that they had merged their shop with VideoEgg. After the dust settles, the new entity will be known as \"SAY Media, a modern media company.\" Anil Dash's \"SAY, Goodbye to Six Apart,\"\u2026","rel":"","context":"In "On Weblogs"","block_context":{"text":"On Weblogs","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/on_weblogs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6206,"url":"https:\/\/www.earthwidemoth.com\/blog\/2005\/01\/10\/coded\/","url_meta":{"origin":7165,"position":2},"title":"Coded","author":"Derek Mueller","date":"January 10, 2005","format":false,"excerpt":"I'm mucking around all morning with MT RSS tags.\u00a0 I was using a chunk of javascript to pull in delicious bookmarks before, but I wanted a bit more flexibility. Figured MT RSS would deliver. So I read around the net--mostly old entries from the 2.+ days--and came up with a\u2026","rel":"","context":"In "On Weblogs"","block_context":{"text":"On Weblogs","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/on_weblogs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7465,"url":"https:\/\/www.earthwidemoth.com\/blog\/2015\/12\/22\/breaktest\/","url_meta":{"origin":7165,"position":3},"title":"Breaktest","author":"Derek Mueller","date":"December 22, 2015","format":false,"excerpt":"An old blog breaks down. Stops working. Fails to grant access to even the control panel, not that anyone remembers the username and pissword, anyway. There's bondo in the basement, duct tape in a kitchen junk drawer (no, the other junk drawer; the junkier drunk drawer). And then there's some\u2026","rel":"","context":"In "Invention"","block_context":{"text":"Invention","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/invention\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6576,"url":"https:\/\/www.earthwidemoth.com\/blog\/2006\/06\/19\/as-graphs-1\/","url_meta":{"origin":7165,"position":4},"title":"As Graphs","author":"Derek Mueller","date":"June 19, 2006","format":false,"excerpt":"In with the URL, out with this: an html-tags-as-graphs approximation of this page.\u00a0 Movable Type is responsible for much of the structure. Still, there you have it--a good (and mighty granular) example of computational methods and visualization combined to offer up a projection of a localized complex. It looks to\u2026","rel":"","context":"In "Methods"","block_context":{"text":"Methods","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/method\/"},"img":{"alt_text":"http:\/\/www.earthwidemoth.com\/mt\/","src":"https:\/\/i0.wp.com\/static.flickr.com\/45\/170675154_cd9e8a7684_m.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":7128,"url":"https:\/\/www.earthwidemoth.com\/blog\/2008\/08\/15\/mt-42\/","url_meta":{"origin":7165,"position":5},"title":"MT 4.2","author":"Derek Mueller","date":"August 15, 2008","format":false,"excerpt":"I just bussed in all of the upgrade files for Movable Type 4.2, so I had to hustle together an entry to see whether it lives up to the hoopla, especially the faster page-creation times, which had become downright arthritic with the latest releases (e.g., 4.x). So far, I can\u2026","rel":"","context":"In "On Weblogs"","block_context":{"text":"On Weblogs","link":"https:\/\/www.earthwidemoth.com\/blog\/category\/on_weblogs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/posts\/7165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/comments?post=7165"}],"version-history":[{"count":0,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/posts\/7165\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/media?parent=7165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/categories?post=7165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.earthwidemoth.com\/blog\/wp-json\/wp\/v2\/tags?post=7165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}