{"id":102788,"date":"2021-03-03T16:41:02","date_gmt":"2021-03-03T07:41:02","guid":{"rendered":"https:\/\/support.questetra.com\/?p=102788"},"modified":"2022-05-26T13:32:33","modified_gmt":"2022-05-26T04:32:33","slug":"converter-timestamp-number-to-datetime","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-timestamp-number-to-datetime\/","title":{"rendered":"Converter: Timestamp-Number to Datetime"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Converter: Timestamp-Number to Datetime<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A: Set Timestamp Number (eg &#8220;1234567890&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> B: Select DATETIME that stores Converted Datetime (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strTimestamp       = configs.get( &quot;StrConfA&quot; ); \/\/ required\n  if( strTimestamp     === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A: Timestamp} is empty \\n&quot; );\n  }\n  let numTimestamp       = parseInt( strTimestamp, 10 );\nconst dtPocketOutput     = configs.getObject( &quot;SelectConfB&quot; );\nengine.log( &quot; AutomatedTask: Workflow Platform offset: &quot; +\n            (engine.getTimeZoneOffsetInMinutes() \/60) );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/let dateUniversal  = new Date( numTimestamp * 1000 );\nlet numMsecUniversal = numTimestamp * 1000;\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( dtPocketOutput,      new java.sql.Timestamp( numMsecUniversal ) );\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/*\nNotes:\n- Unix time acquired by API communication or Webhook reception can be converted to Datetime data.\n    - Seconds less than a minute are truncated. (YYYY-MM-DD hh:mm)\n    - The limit of Datetime type data in the Workflow Platform is &quot;1900 to 2100&quot;.\n    - https:\/\/support.questetra.com\/data-items\/datetime-type\/\n- Unix time is the number of seconds that have elapsed since the Unix epoch, minus leap seconds.\n    - The Unix epoch is 00:00:00 UTC on 1 January 1970 (an arbitrary date).\n    - Unix time is also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time.\n    - ECMAScript epoch time (&quot;milliseconds&quot;) is 1000 times the value of Unix time (&quot;seconds&quot;).\n\nNotes-ja:\n- API\u901a\u4fe1\u3084Webhook\u53d7\u4fe1\u7b49\u3067\u53d6\u5f97\u3055\u308c\u305fUnix\u6642\u9593\uff08\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\uff09\u3092\u6642\u523b\u578b\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3067\u304d\u307e\u3059\u3002\n    - \u5206\u4ee5\u4e0b\u306e\u79d2\u6570\u306f\u5207\u308a\u6368\u3066\u3089\u308c\u307e\u3059\u3002 (YYYY-MM-DD hh:mm)\n    - \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306b\u304a\u3051\u308b\u6642\u523b\u578b\u30c7\u30fc\u30bf\u306e\u5236\u9650\u306f\u300c1900\u5e74\u304b\u30892100\u5e74\u307e\u3067\u300d\u3067\u3059\u3002\n    - https:\/\/support.questetra.com\/ja\/data-items\/datetime-type\/\n- Unix\u6642\u9593\u306f\u300cUnix\u30a8\u30dd\u30c3\u30af\u300d\u304b\u3089\u306e\u7d4c\u904e\u79d2\u6570\u3067\u3059\u3002\uff08\u3046\u308b\u3046\u79d2\u306e\u5b58\u5728\u306f\u6392\u9664\u3055\u308c\u307e\u3059\uff09\n    - Unix\u30a8\u30dd\u30c3\u30af\u306f\u3001\u5354\u5b9a\u4e16\u754c\u6642\uff08UTC\uff09\u306e1970\u5e741\u67081\u65e500:00:00\u3092\u6307\u3057\u307e\u3059\u3002\uff08\u610f\u5473\u306e\u3042\u308b\u65e5\u3067\u306f\u306a\u3044\uff09\n    - Unix\u6642\u9593\u306f\u3001Unix\u30bf\u30a4\u30e0\u3001\u30a8\u30dd\u30c3\u30af\u30bf\u30a4\u30e0\u3001POSIX\u30bf\u30a4\u30e0\u3001Unix\u30a8\u30dd\u30c3\u30af\u30bf\u30a4\u30e0\u306a\u3069\u3068\u3082\u547c\u3070\u308c\u307e\u3059\u3002\n    - ECMAScript epoch time\uff08&quot;\u7d4c\u904e\u30df\u30ea\u79d2\u6570&quot;\uff09\u306f\u3001Unix time\uff08&quot;\u7d4c\u904e\u79d2\u6570&quot;\uff09\u306e1000\u500d\u306e\u5024\u306b\u306a\u308a\u307e\u3059\u3002\n*\/\n\n\n\/*\nAPPENDIX\n- Wikipedia: Unix Time, UTC\n    - https:\/\/en.wikipedia.org\/wiki\/Unix_time\n    - https:\/\/en.wikipedia.org\/wiki\/Coordinated_Universal_Time\n- Note, the &quot;Serial Number&quot; in Spreadsheet or Excel is the number of days since 1899-12-30 00:00.\n    - https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption\n\nAPPENDIX-ja\n- Wikipedia: Unix Time, UTC\n    - https:\/\/ja.wikipedia.org\/wiki\/UNIX%E6%99%82%E9%96%93\n    - https:\/\/ja.wikipedia.org\/wiki\/%E5%8D%94%E5%AE%9A%E4%B8%96%E7%95%8C%E6%99%82\n- \u306a\u304a\u3001Spreadsheet \u3084 Excel \u306b\u304a\u3051\u308b &quot;Serial Number&quot; \u306f\u30011899-12-30 00:00 \u304b\u3089\u306e\u7d4c\u904e\u65e5\u6570\u3067\u3059\u3002\n    - https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption\n*\/\n\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACmElEQVRYR8WXT0gUcRTHP8PSItka\nFkTkZRcSwpuCEARW0jlkoUNRh1pxxy4WBJ324kEMkzpI7qLbLpQFCnvx4M0FkRAMNwJha6M\/ZBlF\nbR1WM4KJn9Ows7Mzs+O4MnOd977v83u\/997v95Pw+JMcx0+wH4UwEmdRaEciCDT\/9y+i8B6JHApZ\nJDJE2XCiXRsgxVH+cBuQgQYnosBvII6fO1zli52PPUAcGYm7QKPDwEazEgq3kIlb+VsDJHgA9LsM\nbHQbJ8p1My1zgDhPkLhYp+CqjMJTZC4ZNasB6rvympmoBFD3fLyuKzeKKfTra6IMoFb7m10UnFPu\nEn6Oa91RBkhwD7jhVMXObqJrgsy7DHMf56zM7hPlpvipAoghA9930Oe2nKsXVmnyN9G30GcFIebE\nYTGsVIA4l5F4pFftPtZNS2OLq4TEOmK0HmxlrbRmDaFwBZnHWgaSwDV9NLGKtuY2VwB6JxuIh0SJ\naBlYQaJ9LwA2\/24y\/GKYwZXBysUo5JDp0DLwQ3ewbBtOdk3SeaTTVQaCB4LbNSCCj74cJfY8ZqZT\nJMohDUBxFcnCSWxfKBCyC656RpFqAgT2BUieTrK+sc7AswFHnIvnF8l+zlqtvKyhA6jaAmElgqfO\npOgJ9pB+laZ3odcRgEMj3RbEqSpCfXCf5GPp6xKFXwWH2pVm85\/mSb9O2xZhVRtOn5smHAojgu\/2\nS+aTZtmraMOqQTR2aozIiQgNPqeXIGtMUwDDIDIdxXqImbczzH6YdZWM\/M88y9+W9b6GUSx+WRxG\nGsRUYaqeRWg4jASAzXE8cnKE4laRodyQqwwYnCyOY2Hl6YVEw\/T0SqZBeHop3ZtM7PBaXs6Ehw8T\nDcLTp5m+fzx7nNaj8200\/gGQ3PghXmX6mAAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1dDvGzyz0BCnB7ssQxZ8FVzZpZuKqSFQ_\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Converter-Timestamp-Number-to-Datetime.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-03-01 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-datetimes-in-difference-timezones\/\">https:\/\/support.questetra.com\/addons\/converter-datetimes-in-difference-timezones\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Addon-import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Unix time acquired by API communication or Webhook reception can be converted to Datetime data.<ul><li>Seconds less than a minute are truncated. (YYYY-MM-DD hh:mm)<\/li><li>The limit of Datetime type data in the Workflow Platform is &#8220;1900 to 2100&#8221;.<\/li><li><a href=\"https:\/\/support.questetra.com\/data-items\/datetime-type\/\">https:\/\/support.questetra.com\/data-items\/datetime-type\/<\/a><\/li><\/ul><\/li><li>Unix time is the number of seconds that have elapsed since the Unix epoch, minus leap seconds.<ul><li>The Unix epoch is 00:00:00 UTC on 1 January 1970 (an arbitrary date).<\/li><li>Unix time is also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time.<\/li><li>ECMAScript epoch time (&#8220;milliseconds&#8221;) is 1000 times the value of Unix time (&#8220;seconds&#8221;).<\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"102791\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/converter-timestamp-number-to-datetime\/attachment\/converter-timestamp-number-to-datetime-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Converter-Timestamp-Number-to-Datetime-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)\" class=\"wp-image-102791\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Wikipedia: Unix Time, UTC<ul><li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Unix_time\" rel=\"nofollow\">https:\/\/en.wikipedia.org\/wiki\/Unix_time<\/a><\/li><li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Coordinated_Universal_Time\" rel=\"nofollow\">https:\/\/en.wikipedia.org\/wiki\/Coordinated_Universal_Time<\/a><\/li><\/ul><\/li><li>Note, the &#8220;Serial Number&#8221; in Spreadsheet or Excel is the number of days since 1899-12-30 00:00.<ul><li><a href=\"https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption\" rel=\"nofollow\">https:\/\/developers.google.com\/sheets\/api\/reference\/rest\/v4\/DateTimeRenderOption<\/a><\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"1R1a6tj9KV\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-iso-datetime-string-to-workflow-datetime\/\">Converter: ISO-Datetime-String to Workflow Datetime<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Converter: ISO-Datetime-String to Workflow Datetime&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/converter-iso-datetime-string-to-workflow-datetime\/embed\/#?secret=bQpzQYAuAb#?secret=1R1a6tj9KV\" data-secret=\"1R1a6tj9KV\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)<\/p>\n","protected":false},"author":2,"featured_media":102789,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[382,365],"class_list":["post-102788","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-date","tag-easy-config-addon"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":2,"uagb_excerpt":"Converts a timestamp number (UNIX time) to datetime data. That is, the number of seconds elapsed since UTC 1970-01-01 00:00:00 is assigned to the datetime type data according to the workflow platform time zone. (10-digit integer after 2002)","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-qJS","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":102795,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-timestamp-number-to-datetime\/","url_meta":{"origin":102788,"position":0},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 to \u65e5\u6642","author":"IMAMURA, Genichi","date":"2021-03-03","format":false,"excerpt":"\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5024\uff08UNIX\u30bf\u30a4\u30e0\uff09\u3092\u65e5\u6642\u578b\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u3059\u306a\u308f\u3061\u3001\u5354\u5b9a\u4e16\u754c\u6642 1970-01-01 00:00:00 \u304b\u3089\u306e\u7d4c\u904e\u79d2\u6570\uff082002\u5e74\u4ee5\u964d\u306f10\u6841\u6574\u6570\uff09\u304b\u3089\u3001\u6642\u523b\u578b\u30c7\u30fc\u30bf\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306b\u5f93\u3044\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u30b3\u30f3\u30d0\u30fc\u30bf: \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 to \u65e5\u6642","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Timestamp-Number-to-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":102802,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-iso-datetime-string-to-workflow-datetime\/","url_meta":{"origin":102788,"position":1},"title":"Converter: ISO-Datetime-String to Workflow Datetime","author":"IMAMURA, Genichi","date":"2021-03-03","format":false,"excerpt":"Converts ISO 8601 datetime string data (\"2021-12-31T20:34:56+09:00\", \"2021-12-31T11:34:56.789Z\", etc.) to Datetime type data (\"2021-12-31 20:34\"). The Datetime type data is based on the time zone configured for your Workflow Platform.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: ISO-Datetime-String to Workflow Datetime","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":102820,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-workflow-datetime-to-iso-datetime-string\/","url_meta":{"origin":102788,"position":2},"title":"Converter: Workflow Datetime to ISO-Datetime-String","author":"IMAMURA, Genichi","date":"2021-03-03","format":false,"excerpt":"Converts Datetime type data (\"2021-12-31 20:34\" JST) into ISO 8601 datetime string data (\"2021-12-31T20:34:00+09:00\" or \"2021-12-31T11:34:00Z\"). As a general rule Datetime type data is regarded as the time of the Workflow Platform time zone.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: Workflow Datetime to ISO-Datetime-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Workflow-Datetime-to-ISO-Datetime-String-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":102837,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-datetimes-in-difference-timezones\/","url_meta":{"origin":102788,"position":3},"title":"Converter: Datetimes in different time zones","author":"IMAMURA, Genichi","date":"2021-03-03","format":false,"excerpt":"Converts the datetime in time zone A to the datetime in time zone B. Any time zone can be set for either datetimes. If nothing is set the Workflow Platform time zone will be applied.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Datetimes-in-different-time-zones-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Datetimes-in-different-time-zones-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Datetimes-in-different-time-zones-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Datetimes-in-different-time-zones-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-Datetimes-in-different-time-zones-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":140397,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-date-or-datetime-string-to-workflow-datetime-2022\/","url_meta":{"origin":102788,"position":4},"title":"Converter: Date-or-Datetime-String to Workflow Datetime","author":"IMAMURA, Genichi","date":"2022-12-29","format":false,"excerpt":"Converts strings such as \"2022-12-31\" or \"2022-12-31 00:00\" to Datetime (or Date) data. Also supports strings like \"2022\/12\/31\" and \"19700101\". Any string is evaluated as local time. The timestamp value (seconds since 1 Jan 1970) is also gettable.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/12\/converter-date-or-datetime-string-to-workflow-datetime-2022-capture-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":102811,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-iso-datetime-string-to-workflow-datetime\/","url_meta":{"origin":102788,"position":5},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: ISO\u65e5\u6642\u6587\u5b57\u5217 to \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642","author":"IMAMURA, Genichi","date":"2021-03-03","format":false,"excerpt":"ISO 8601 \u65e5\u6642\u6587\u5b57\u5217\u30c7\u30fc\u30bf\uff08\"2021-12-31T20:34:56+09:00\", \"2021-12-31T11:34:56.789Z\", \u7b49\uff09\u3092\u65e5\u6642\u578b\u30c7\u30fc\u30bf\uff08\"2021-12-31 12:34\"\uff09\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u65e5\u6642\u578b\u30c7\u30fc\u30bf\u306f\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306b\u57fa\u3065\u3044\u3066\u8a55\u4fa1\u8868\u793a\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u30b3\u30f3\u30d0\u30fc\u30bf: ISO\u65e5\u6642\u6587\u5b57\u5217 to \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u65e5\u6642","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/Converter-ISO-Datetime-String-to-Workflow-Datetime-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=102788"}],"version-history":[{"count":5,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102788\/revisions"}],"predecessor-version":[{"id":113725,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102788\/revisions\/113725"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/102789"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=102788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=102788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=102788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}