{"id":1843,"date":"2009-02-20T23:13:30","date_gmt":"2009-02-20T23:13:30","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/?p=1843"},"modified":"2009-02-20T23:13:30","modified_gmt":"2009-02-20T23:13:30","slug":"date-and-time-to-number-conversions","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2009\/02\/20\/date-and-time-to-number-conversions\/","title":{"rendered":"Date and Time to Number Conversions"},"content":{"rendered":"<p>Code developed and kindly donated by Murthy Suresh.<\/p>\n<pre><span style=\"color: #0000BB\"><\/span><span style=\"color: #000000\">{\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">dd_&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">StrToNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">StrRight<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">aaaammdd<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">2&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/\/printf(WriteVal(dd_)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;);\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">mm_&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">StrToNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">StrMid<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">aaaammdd<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">4<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">2&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/\/printf(WriteVal(mm_)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;);\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">aa_&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">StrToNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">StrLeft<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">aaaammdd<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">4&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/\/printf(WriteVal(aa_)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;+&nbsp;\"\\n&quot;&nbsp;);\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">Date_Num&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;(&nbsp;<\/span><span style=\"color: #0000BB\">10000&nbsp;<\/span><span style=\"color: #000000\">*&nbsp;(&nbsp;<\/span><span style=\"color: #0000BB\">aa_&nbsp;<\/span><span style=\"color: #000000\">-&nbsp;<\/span><span style=\"color: #0000BB\">1900&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;)&nbsp;+&nbsp;(&nbsp;<\/span><span style=\"color: #0000BB\">100&nbsp;<\/span><span style=\"color: #000000\">*&nbsp;<\/span><span style=\"color: #0000BB\">mm_&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;+&nbsp;<\/span><span style=\"color: #0000BB\">dd_<\/span><span style=\"color: #000000\">;\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">RESULT&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">Date_Num<\/span><span style=\"color: #000000\">;\r&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;<\/span><span style=\"color: #0000BB\">RESULT<\/span><span style=\"color: #000000\">;\r}\r\rfunction&nbsp;<\/span><span style=\"color: #0000BB\">Time_To_Num<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">strTime&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;<\/span><span style=\"color: #007000\">\/\/&nbsp;format&nbsp;for&nbsp;time&nbsp;is&nbsp;hh:mm:ss\r<\/span><span style=\"color: #000000\">{\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/*\r&nbsp;&nbsp;&nbsp;&nbsp;\/\/do&nbsp;something&nbsp;to&nbsp;raise&nbsp;alert&nbsp;&nbsp;if&nbsp;length&nbsp;does&nbsp;not&nbsp;match\r&nbsp;&nbsp;&nbsp;&nbsp;????PopupWindow(\"Current&nbsp;time&nbsp;is:&nbsp;&quot;&nbsp;+&nbsp;Now(),\"Alert\",&nbsp;2,\r&nbsp;&nbsp;&nbsp;&nbsp;640*mtRandom(),&nbsp;480*mtRandom());\r&nbsp;&nbsp;&nbsp;&nbsp;*\/\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">hh_t&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">StrToNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">StrLeft<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">strTime<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">2&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/\/printf(WriteVal(&nbsp;hh_t&nbsp;)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;);\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">mm_t&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">StrToNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">StrMid<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">strTime<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">3<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">2&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/\/printf(WriteVal(&nbsp;mm_t&nbsp;)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;);\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">ss_t&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">StrToNum<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">StrRight<\/span><span style=\"color: #000000\">(&nbsp;<\/span><span style=\"color: #0000BB\">strTime<\/span><span style=\"color: #000000\">,&nbsp;<\/span><span style=\"color: #0000BB\">2&nbsp;<\/span><span style=\"color: #000000\">)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #007000\">\/\/printf(WriteVal(&nbsp;ss_t&nbsp;)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;+&nbsp;\"\\n&quot;&nbsp;&nbsp;);\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">Time_Num&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">10000&nbsp;<\/span><span style=\"color: #000000\">*&nbsp;<\/span><span style=\"color: #0000BB\">hh_t&nbsp;<\/span><span style=\"color: #000000\">+&nbsp;<\/span><span style=\"color: #0000BB\">100&nbsp;<\/span><span style=\"color: #000000\">*&nbsp;<\/span><span style=\"color: #0000BB\">mm_t&nbsp;<\/span><span style=\"color: #000000\">+&nbsp;<\/span><span style=\"color: #0000BB\">ss_t<\/span><span style=\"color: #000000\">;\r&nbsp;&nbsp;&nbsp;&nbsp;<\/span><span style=\"color: #0000BB\">RESULT&nbsp;<\/span><span style=\"color: #000000\">=&nbsp;<\/span><span style=\"color: #0000BB\">Time_Num<\/span><span style=\"color: #000000\">;\r&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;<\/span><span style=\"color: #0000BB\">RESULT<\/span><span style=\"color: #000000\">;<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Code developed and kindly donated by Murthy Suresh. { &nbsp;&nbsp;&nbsp;&nbsp;dd_&nbsp;=&nbsp;StrToNum(&nbsp;StrRight(&nbsp;aaaammdd,&nbsp;2&nbsp;)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;\/\/printf(WriteVal(dd_)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;mm_&nbsp;=&nbsp;StrToNum(&nbsp;StrMid(&nbsp;aaaammdd,&nbsp;4,&nbsp;2&nbsp;)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;\/\/printf(WriteVal(mm_)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;aa_&nbsp;=&nbsp;StrToNum(&nbsp;StrLeft(&nbsp;aaaammdd,&nbsp;4&nbsp;)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;\/\/printf(WriteVal(aa_)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;+&nbsp;&#8220;\\n&quot;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;Date_Num&nbsp;=&nbsp;(&nbsp;10000&nbsp;*&nbsp;(&nbsp;aa_&nbsp;&#8211;&nbsp;1900&nbsp;)&nbsp;)&nbsp;+&nbsp;(&nbsp;100&nbsp;*&nbsp;mm_&nbsp;)&nbsp;+&nbsp;dd_; &nbsp;&nbsp;&nbsp;&nbsp;RESULT&nbsp;=&nbsp;Date_Num; &nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;RESULT; } function&nbsp;Time_To_Num(&nbsp;strTime&nbsp;)&nbsp;\/\/&nbsp;format&nbsp;for&nbsp;time&nbsp;is&nbsp;hh:mm:ss { &nbsp;&nbsp;&nbsp;&nbsp;\/* &nbsp;&nbsp;&nbsp;&nbsp;\/\/do&nbsp;something&nbsp;to&nbsp;raise&nbsp;alert&nbsp;&nbsp;if&nbsp;length&nbsp;does&nbsp;not&nbsp;match &nbsp;&nbsp;&nbsp;&nbsp;????PopupWindow(&#8220;Current&nbsp;time&nbsp;is:&nbsp;&quot;&nbsp;+&nbsp;Now(),&#8221;Alert&#8221;,&nbsp;2, &nbsp;&nbsp;&nbsp;&nbsp;640*mtRandom(),&nbsp;480*mtRandom()); &nbsp;&nbsp;&nbsp;&nbsp;*\/ &nbsp;&nbsp;&nbsp;&nbsp;hh_t&nbsp;=&nbsp;StrToNum(&nbsp;StrLeft(&nbsp;strTime,&nbsp;2&nbsp;)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;\/\/printf(WriteVal(&nbsp;hh_t&nbsp;)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;mm_t&nbsp;=&nbsp;StrToNum(&nbsp;StrMid(&nbsp;strTime,&nbsp;3,&nbsp;2&nbsp;)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;\/\/printf(WriteVal(&nbsp;mm_t&nbsp;)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;ss_t&nbsp;=&nbsp;StrToNum(&nbsp;StrRight(&nbsp;strTime,&nbsp;2&nbsp;)&nbsp;);&nbsp;&nbsp;&nbsp;&nbsp;\/\/printf(WriteVal(&nbsp;ss_t&nbsp;)&nbsp;+&nbsp;&quot;&nbsp;&quot;&nbsp;&nbsp;+&nbsp;&#8220;\\n&quot;&nbsp;&nbsp;); &nbsp;&nbsp;&nbsp;&nbsp;Time_Num&nbsp;=&nbsp;10000&nbsp;*&nbsp;hh_t&nbsp;+&nbsp;100&nbsp;*&nbsp;mm_t&nbsp;+&nbsp;ss_t; &nbsp;&nbsp;&nbsp;&nbsp;RESULT&nbsp;=&nbsp;Time_Num; &nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;RESULT;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[78,1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1843"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=1843"}],"version-history":[{"count":0,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1843\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=1843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=1843"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=1843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}