{"id":48,"date":"2015-08-28T11:21:56","date_gmt":"2015-08-28T08:21:56","guid":{"rendered":"https:\/\/amsd.go.ro\/wordpress\/?p=48"},"modified":"2021-09-07T11:26:22","modified_gmt":"2021-09-07T08:26:22","slug":"converting-remedy-timestamp-into-oracle-datetime-format","status":"publish","type":"post","link":"https:\/\/amsd.go.ro\/wordpress\/?p=48","title":{"rendered":"Converting Remedy timestamp into Oracle DateTime format"},"content":{"rendered":"<p>I need a formula that converts the Remedy timestamp into Oracle date\/time field. I have referred to KB article: <strong>000000006132<\/strong> and formula given in the article is working fine.<\/p>\n<p><span style=\"font-family: courier new,courier;\"><span class=\"kw1\">SELECT<\/span> TO_CHAR<span class=\"br0\">(<\/span>TO_DATE<span class=\"br0\">(<\/span><span class=\"st0\">&#8217;01\/01\/1970 00:00:00&#8242;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&#8216;MM\/DD\/YYYY HH24:MI:SS&#8217;<\/span><span class=\"br0\">)<\/span> <span class=\"sy0\">+<\/span> <span class=\"br0\">(<\/span>C3 <span class=\"sy0\">\/<\/span> <span class=\"br0\">(<\/span> <span class=\"nu0\">60<\/span> <span class=\"sy0\">*<\/span> <span class=\"nu0\">60<\/span> <span class=\"sy0\">*<\/span> <span class=\"nu0\">24<\/span> <span class=\"br0\">)<\/span><span class=\"br0\">)<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&#8216;MM\/DD\/YY HH24:MI:SS&#8217;<\/span><span class=\"br0\">)<\/span> <span class=\"kw1\">FROM<\/span> T40;<\/span><\/p>\n<p>The returned date\/time value is in GMT timezone.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I need a formula that converts the Remedy timestamp into Oracle date\/time field. I have referred to KB article: 000000006132 and formula given in the article is working fine. SELECT TO_CHAR(TO_DATE(&#8217;01\/01\/1970 00:00:00&#8242;, &#8216;MM\/DD\/YYYY HH24:MI:SS&#8217;) + (C3 \/ ( 60 * [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/amsd.go.ro\/wordpress\/?p=48#more-48\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">Converting Remedy timestamp into Oracle DateTime format<\/span><\/a><\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,14,17,8,10,18,12],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-technology","tag-ps_40","tag-ps_41","tag-ps_33","tag-ps_20","tag-ps_32","tag-ps_39","tag-ps_17"],"_links":{"self":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=48"}],"version-history":[{"count":1,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":193,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/48\/revisions\/193"}],"wp:attachment":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}