{"id":4954,"date":"2017-06-28T22:40:44","date_gmt":"2017-06-28T22:40:44","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=4954"},"modified":"2020-07-01T10:02:31","modified_gmt":"2020-07-01T17:02:31","slug":"converting-unix-time-to-other-formats","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/converting-unix-time-to-other-formats\/","title":{"rendered":"Converting Unix Time to Other Formats"},"content":{"rendered":"<p>Some systems use a time stamp that is commonly referred to by one of the following names:<\/p>\n<ul>\n<li>Unix time<\/li>\n<li>Unit timestamp<\/li>\n<li>POSIX time<\/li>\n<\/ul>\n<p>The time is the number of milliseconds from 1 January 1970 12:00:00 UTC. For example,\u00a01498683392 is the 28th of June, 2017, which is the date this post is authored.<\/p>\n<p>To convert the value to a common format, create variables for the Unix time and the formatted value, and then use a Date Format procedure to convert it to the format you want to use:<\/p>\n<ol>\n<li>Create a variable and set it to the Unix time value. The example names this variable UnixTime.<\/li>\n<li>Create a second variable that you set in the procedure to the formatted time. The example names this variable MonthDayYear, because it uses that format.<\/li>\n<li>Create a procedure and use the variable that contains the Unix time:<img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-4955 aligncenter\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime-300x176.jpg\" alt=\"\" width=\"300\" height=\"176\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime-300x176.jpg 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime-150x88.jpg 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime-250x146.jpg 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime-308x180.jpg 308w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime.jpg 369w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Add a Date Format action to the procedure. This example uses Long date format. Numerous formats are available.<img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-4956 aligncenter\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime2-300x126.jpg\" alt=\"\" width=\"300\" height=\"126\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime2-300x126.jpg 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime2-150x63.jpg 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime2-250x105.jpg 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime2.jpg 310w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Add a Set Variable action and set the variable MonthDayYear.<img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-4957 aligncenter\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime3-300x115.jpg\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime3-300x115.jpg 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime3-150x57.jpg 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime3-250x95.jpg 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime3.jpg 343w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Verify the values in the Variables window.<img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-4958 aligncenter\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime4.jpg\" alt=\"\" width=\"251\" height=\"105\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime4.jpg 251w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime4-150x63.jpg 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2017\/06\/UnixTime4-250x105.jpg 250w\" sizes=\"(max-width: 251px) 100vw, 251px\" \/><\/li>\n<li>Save your changes.<\/li>\n<\/ol>\n<p><a href=\"\/support\/wp-content\/uploads\/2017\/06\/TimeSample.zip\">Download the sample project<\/a>, TimeSample.efz, to see a project that uses the procedure described in this post. Just unzip the file, start the eFORMz Composer, and open TimeSample.efz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some systems use a time stamp that is commonly referred to by one of the following names: Unix time Unit timestamp POSIX time The time is the number of milliseconds from 1 January 1970 12:00:00 UTC. For example,\u00a01498683392 is the 28th of June, 2017, which is the date this post is authored. To convert the [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[115,7],"tags":[204,207,205,206],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4954"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=4954"}],"version-history":[{"count":2,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4954\/revisions"}],"predecessor-version":[{"id":8138,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4954\/revisions\/8138"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=4954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=4954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=4954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}