{"id":515,"date":"2012-02-21T09:52:52","date_gmt":"2012-02-21T07:52:52","guid":{"rendered":"https:\/\/polyetilen.lt\/?p=515"},"modified":"2023-05-02T09:38:55","modified_gmt":"2023-05-02T06:38:55","slug":"calculate-days-between-dates","status":"publish","type":"post","link":"https:\/\/polyetilen.lt\/en\/calculate-days-between-dates","title":{"rendered":"Calculate days between dates"},"content":{"rendered":"<p>Using php strtotime function difference between dates:<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n\/\/number of seconds between two dates\r\n$s = strtotime(&quot;2012-02-21 00:00:00&quot;) - strtotime(&quot;2011-02-21 00:00:00&quot;);\r\n\/\/how many days between two dates\r\necho $s\/60\/60\/24;\r\n<\/pre>\n<p>Another way to set date with mktime function:<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n\/\/number of seconds between two dates\r\n$s = mktime(0, 0, 0, 21, 02, 2012) - mktime(0, 0, 0, 21, 02, 2011);\r\n\/\/how many days between two dates\r\necho $s\/60\/60\/24;\r\n<\/pre>\n<p>Before PHP 5.1.0 negative timestamps were not supported. Under any known version of Windows date could be from 1970 to 2038 years.<\/p>\n<p>And using MySQL difference between dates:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT TO_DAYS('2012-02-21 00:00:00') - TO_DAYS('2011-02-21 00:00:00');\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Using php strtotime function difference between dates: \/\/number of seconds between two dates $s = strtotime(&quot;2012-02-21 00:00:00&quot;) - strtotime(&quot;2011-02-21 00:00:00&quot;); \/\/how many days between two dates echo $s\/60\/60\/24; Another way to set date with mktime &hellip; <a href=\"https:\/\/polyetilen.lt\/en\/calculate-days-between-dates\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"http:\/\/polyetilen.lt\/?p=266","footnotes":""},"categories":[8],"tags":[75,83,96,32,34,95,93,94],"class_list":["post-515","post","type-post","status-publish","format-standard","hentry","category-programavimas","tag-data","tag-laikas","tag-mktime","tag-mysql","tag-php","tag-skirtumas","tag-strtotime","tag-to_days","en-US"],"_links":{"self":[{"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/posts\/515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/comments?post=515"}],"version-history":[{"count":1,"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/posts\/515\/revisions"}],"predecessor-version":[{"id":516,"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/posts\/515\/revisions\/516"}],"wp:attachment":[{"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/media?parent=515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/categories?post=515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/polyetilen.lt\/wp-json\/wp\/v2\/tags?post=515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}