{"id":67072,"date":"2024-06-17T20:09:04","date_gmt":"2024-06-17T16:39:04","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/"},"modified":"2024-06-17T20:09:04","modified_gmt":"2024-06-17T16:39:04","slug":"working-with-dates-and-times-in-sql-tips-and-tricks-4o4e","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/","title":{"rendered":"\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 SQL: \u0646\u06a9\u0627\u062a \u0648 \u062a\u0631\u0641\u0646\u062f\u0647\u0627"},"content":{"rendered":"<div data-article-id=\"1891448\" id=\"article-body\">\n<p>\u0645\u062f\u06cc\u0631\u06cc\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u06cc\u06a9 \u062c\u0646\u0628\u0647 \u062d\u06cc\u0627\u062a\u06cc \u0627\u0632 \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.  SQL \u0627\u0646\u0648\u0627\u0639 \u062a\u0648\u0627\u0628\u0639 \u0648 \u062a\u06a9\u0646\u06cc\u06a9 \u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0627\u0631\u0622\u0645\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.  \u0686\u0647 \u0628\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0633\u0627\u062f\u0647 \u062a\u0627\u0631\u06cc\u062e \u0633\u0631 \u0648 \u06a9\u0627\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0648 \u0686\u0647 \u0628\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0632\u0645\u0627\u0646\u060c \u062f\u0631\u06a9 \u0646\u062d\u0648\u0647 \u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 SQL \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a.  \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u062c\u0627\u0645\u0639\u060c \u0646\u06a9\u0627\u062a \u0648 \u062a\u0631\u0641\u0646\u062f\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 SQL\u060c \u0628\u0627 \u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u062a\u0648\u0636\u06cc\u062d \u0647\u0631 \u0645\u0641\u0647\u0648\u0645\u060c \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D8%A2%D8%B4%D9%86%D8%A7%DB%8C%DB%8C_%D8%A8%D8%A7_%D8%A7%D9%86%D9%88%D8%A7%D8%B9_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\" >\u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D8%AF%D8%B1%D8%AC_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\" >\u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D8%A8%D8%A7%D8%B2%DB%8C%D8%A7%D8%A8%DB%8C_%D8%A7%D8%B7%D9%84%D8%A7%D8%B9%D8%A7%D8%AA_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\" >\u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D8%AA%D9%88%D8%A7%D8%A8%D8%B9_%D9%85%D8%B4%D8%AA%D8%B1%DA%A9_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\" >\u062a\u0648\u0627\u0628\u0639 \u0645\u0634\u062a\u0631\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#CURRENT_DATE_%D9%88_CURRENT_TIME\" >CURRENT_DATE \u0648 CURRENT_TIME<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#DATE_ADD_%D9%88_DATE_SUB\" >DATE_ADD \u0648 DATE_SUB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#DATEDIFF\" >DATEDIFF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#DATEPART\" >DATEPART<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D9%85%D8%AF%DB%8C%D8%B1%DB%8C%D8%AA_%D9%85%D9%86%D8%A7%D8%B7%D9%82_%D8%B2%D9%85%D8%A7%D9%86%DB%8C\" >\u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0646\u0627\u0637\u0642 \u0632\u0645\u0627\u0646\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#CONVERT_TZ\" >CONVERT_TZ<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%DA%A9%D8%A7%D8%B1_%D8%A8%D8%A7_%D9%81%D9%88%D8%A7%D8%B5%D9%84\" >\u06a9\u0627\u0631 \u0628\u0627 \u0641\u0648\u0627\u0635\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D9%86%DA%A9%D8%A7%D8%AA_%D9%88_%D8%AA%D8%B1%D9%81%D9%86%D8%AF%D9%87%D8%A7%DB%8C_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C\" >\u0646\u06a9\u0627\u062a \u0648 \u062a\u0631\u0641\u0646\u062f\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D8%A7%D8%B2_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%87%D8%A7%D8%B1%D8%AF%DA%A9%D8%AF_%DA%A9%D8%B1%D8%AF%D9%86_%D8%AE%D9%88%D8%AF%D8%AF%D8%A7%D8%B1%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0647\u0627\u0631\u062f\u06a9\u062f \u06a9\u0631\u062f\u0646 \u062e\u0648\u062f\u062f\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D9%86%D9%85%D8%A7%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%B3%D8%AA%D9%88%D9%86_%D9%87%D8%A7%DB%8C_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE\" >\u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D8%A7%D8%B2_%D8%A7%D9%86%D9%88%D8%A7%D8%B9_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D9%85%D9%86%D8%A7%D8%B3%D8%A8_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0646\u0627\u0633\u0628 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/nabfollower.com\/blog\/working-with-dates-and-times-in-sql-tips-and-tricks-4o4e\/#%D9%86%D8%AA%DB%8C%D8%AC%D9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A2%D8%B4%D9%86%D8%A7%DB%8C%DB%8C_%D8%A8%D8%A7_%D8%A7%D9%86%D9%88%D8%A7%D8%B9_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\"><\/span>\n<p>  \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 SQL \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0631\u0627\u06cc\u062c \u062a\u0631\u06cc\u0646 \u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\n<strong>\u062a\u0627\u0631\u06cc\u062e<\/strong>: \u062a\u0627\u0631\u06cc\u062e \u0647\u0627 \u0631\u0627 \u0628\u062f\u0648\u0646 \u0632\u0645\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u0642\u0627\u0644\u0628: &#8216;YYYY-MM-DD&#8217;.<\/li>\n<li>\n<strong>\u0632\u0645\u0627\u0646<\/strong>: \u0632\u0645\u0627\u0646 \u0631\u0627 \u0628\u062f\u0648\u0646 \u062a\u0627\u0631\u06cc\u062e \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u0641\u0631\u0645\u062a: &#8216;HH:MM:SS&#8217;.<\/li>\n<li>\n<strong>\u0632\u0645\u0627\u0646 \u0642\u0631\u0627\u0631<\/strong>: \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u0642\u0627\u0644\u0628: &#8216;YYYY-MM-DD HH:MM:SS&#8217;.<\/li>\n<li>\n<strong>TIMESTAMP<\/strong>: \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u0628\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u0646\u0637\u0642\u0647 \u0632\u0645\u0627\u0646\u06cc \u062f\u0631 \u0628\u0631\u062e\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\n<strong>INTERVAL<\/strong>: \u0646\u0634\u0627\u0646 \u062f\u0647\u0646\u062f\u0647 \u06cc\u06a9 \u0628\u0627\u0632\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062a\u0627\u0631\u06cc\u062e \u0645\u0641\u06cc\u062f \u0627\u0633\u062a.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AF%D8%B1%D8%AC_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\"><\/span>\n<p>  \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631\u062c \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 \u062c\u062f\u0627\u0648\u0644 \u0634\u0645\u0627 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0686\u0646\u062f \u0646\u0645\u0648\u0646\u0647 \u0647\u0633\u062a\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Inserting a date<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">events<\/span> <span class=\"p\">(<\/span><span class=\"n\">event_date<\/span><span class=\"p\">)<\/span> <span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'2024-06-15'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Inserting a time<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">schedules<\/span> <span class=\"p\">(<\/span><span class=\"n\">start_time<\/span><span class=\"p\">)<\/span> <span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'08:30:00'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Inserting a datetime<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">appointments<\/span> <span class=\"p\">(<\/span><span class=\"n\">appointment_datetime<\/span><span class=\"p\">)<\/span> <span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'2024-06-15 08:30:00'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A8%D8%A7%D8%B2%DB%8C%D8%A7%D8%A8%DB%8C_%D8%A7%D8%B7%D9%84%D8%A7%D8%B9%D8%A7%D8%AA_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\"><\/span>\n<p>  \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0647\u0646\u06af\u0627\u0645 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 <code>SELECT<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0627\u06cc \u0628\u0631\u0627\u06cc \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Retrieving all appointments on a specific date<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">appointments<\/span> <span class=\"k\">WHERE<\/span> <span class=\"nb\">DATE<\/span><span class=\"p\">(<\/span><span class=\"n\">appointment_datetime<\/span><span class=\"p\">)<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'2024-06-15'<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Retrieving all events that start after a specific time<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">events<\/span> <span class=\"k\">WHERE<\/span> <span class=\"nb\">TIME<\/span><span class=\"p\">(<\/span><span class=\"n\">start_time<\/span><span class=\"p\">)<\/span> <span class=\"o\">&gt;<\/span> <span class=\"s1\">'12:00:00'<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Formatting dates<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">DATE_FORMAT<\/span><span class=\"p\">(<\/span><span class=\"n\">event_date<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'%W, %M %e, %Y'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">formatted_date<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">events<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AA%D9%88%D8%A7%D8%A8%D8%B9_%D9%85%D8%B4%D8%AA%D8%B1%DA%A9_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%88_%D8%B2%D9%85%D8%A7%D9%86\"><\/span>\n<p>  \u062a\u0648\u0627\u0628\u0639 \u0645\u0634\u062a\u0631\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>SQL \u062a\u0648\u0627\u0628\u0639 \u0645\u062a\u0639\u062f\u062f\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0645\u0641\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0622\u0646\u0647\u0627 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"CURRENT_DATE_%D9%88_CURRENT_TIME\"><\/span>\n<p>  CURRENT_DATE \u0648 CURRENT_TIME<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0641\u0639\u0644\u06cc \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span> <span class=\"k\">CURRENT_DATE<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">today<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"k\">CURRENT_TIME<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">now<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"DATE_ADD_%D9%88_DATE_SUB\"><\/span>\n<p>  DATE_ADD \u0648 DATE_SUB<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0627\u0632 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0641\u0648\u0627\u0635\u0644 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06cc\u0627 \u06a9\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Adding 7 days to the current date<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">DATE_ADD<\/span><span class=\"p\">(<\/span><span class=\"k\">CURRENT_DATE<\/span><span class=\"p\">,<\/span> <span class=\"n\">INTERVAL<\/span> <span class=\"mi\">7<\/span> <span class=\"k\">DAY<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">next_week<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Subtracting 2 months from the current date<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">DATE_SUB<\/span><span class=\"p\">(<\/span><span class=\"k\">CURRENT_DATE<\/span><span class=\"p\">,<\/span> <span class=\"n\">INTERVAL<\/span> <span class=\"mi\">2<\/span> <span class=\"k\">MONTH<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">two_months_ago<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"DATEDIFF\"><\/span>\n<p>  DATEDIFF<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u062a\u0641\u0627\u0648\u062a \u0628\u06cc\u0646 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Calculating the number of days between two dates<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">DATEDIFF<\/span><span class=\"p\">(<\/span><span class=\"s1\">'2024-06-15'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'2024-06-01'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">days_difference<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"DATEPART\"><\/span>\n<p>  DATEPART<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0628\u062e\u0634 \u062e\u0627\u0635\u06cc \u0627\u0632 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0645\u0627\u0646\u0646\u062f \u0633\u0627\u0644\u060c \u0645\u0627\u0647 \u06cc\u0627 \u0631\u0648\u0632 \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Extracting the year from a date<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"nb\">YEAR<\/span><span class=\"p\">(<\/span><span class=\"n\">event_date<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">event_year<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">events<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Extracting the month from a date<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"k\">MONTH<\/span><span class=\"p\">(<\/span><span class=\"n\">event_date<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">event_month<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">events<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%AF%DB%8C%D8%B1%DB%8C%D8%AA_%D9%85%D9%86%D8%A7%D8%B7%D9%82_%D8%B2%D9%85%D8%A7%D9%86%DB%8C\"><\/span>\n<p>  \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0646\u0627\u0637\u0642 \u0632\u0645\u0627\u0646\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u0646\u0627\u0637\u0642 \u0632\u0645\u0627\u0646\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0645\u062f\u06cc\u0631\u06cc\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u067e\u06cc\u0686\u06cc\u062f\u0647 \u06a9\u0646\u0646\u062f.  \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc SQL \u0627\u063a\u0644\u0628 \u062f\u0627\u0631\u0627\u06cc \u062a\u0648\u0627\u0628\u0639\u06cc \u0628\u0631\u0627\u06cc \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u062a\u0628\u062f\u06cc\u0644 \u0645\u0646\u0637\u0642\u0647 \u0632\u0645\u0627\u0646\u06cc \u0647\u0633\u062a\u0646\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"CONVERT_TZ\"><\/span>\n<p>  CONVERT_TZ<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 datetime \u0631\u0627 \u0627\u0632 \u06cc\u06a9 \u0645\u0646\u0637\u0642\u0647 \u0632\u0645\u0627\u0646\u06cc \u0628\u0647 \u0645\u0646\u0637\u0642\u0647 \u062f\u06cc\u06af\u0631 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Converting a datetime from UTC to Eastern Time<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"n\">CONVERT_TZ<\/span><span class=\"p\">(<\/span><span class=\"s1\">'2024-06-15 12:00:00'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'UTC'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'America\/New_York'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">est_time<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%DA%A9%D8%A7%D8%B1_%D8%A8%D8%A7_%D9%81%D9%88%D8%A7%D8%B5%D9%84\"><\/span>\n<p>  \u06a9\u0627\u0631 \u0628\u0627 \u0641\u0648\u0627\u0635\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0641\u0648\u0627\u0635\u0644 \u0628\u0627\u0632\u0647 \u0632\u0645\u0627\u0646\u06cc \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u0646\u062f \u0648 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062a\u0627\u0631\u06cc\u062e \u0645\u0641\u06cc\u062f \u0647\u0633\u062a\u0646\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Adding an interval of 3 days to the current date<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"k\">CURRENT_DATE<\/span> <span class=\"o\">+<\/span> <span class=\"n\">INTERVAL<\/span> <span class=\"mi\">3<\/span> <span class=\"k\">DAY<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">future_date<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Subtracting an interval of 1 hour from the current time<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"k\">CURRENT_TIME<\/span> <span class=\"o\">-<\/span> <span class=\"n\">INTERVAL<\/span> <span class=\"mi\">1<\/span> <span class=\"n\">HOUR<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">past_time<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%DA%A9%D8%A7%D8%AA_%D9%88_%D8%AA%D8%B1%D9%81%D9%86%D8%AF%D9%87%D8%A7%DB%8C_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C\"><\/span>\n<p>  \u0646\u06a9\u0627\u062a \u0648 \u062a\u0631\u0641\u0646\u062f\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B2_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE_%D9%87%D8%A7%D8%B1%D8%AF%DA%A9%D8%AF_%DA%A9%D8%B1%D8%AF%D9%86_%D8%AE%D9%88%D8%AF%D8%AF%D8%A7%D8%B1%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0647\u0627\u0631\u062f\u06a9\u062f \u06a9\u0631\u062f\u0646 \u062e\u0648\u062f\u062f\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u062a\u0627\u0631\u06cc\u062e \u0647\u0627\u06cc \u0647\u0627\u0631\u062f\u06a9\u062f \u062f\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc SQL \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u0646\u062c\u0631 \u0628\u0647 \u0686\u0627\u0644\u0634 \u0647\u0627\u06cc \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0634\u0648\u062f.  \u062f\u0631 \u0639\u0648\u0636\u060c \u0627\u0632 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u06cc\u0627 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u067e\u0648\u06cc\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Avoid hardcoding dates<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">events<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">event_date<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'2024-06-15'<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Use dynamic date functions<\/span>\n<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">events<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">event_date<\/span> <span class=\"o\">=<\/span> <span class=\"k\">CURRENT_DATE<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%B3%D8%AA%D9%88%D9%86_%D9%87%D8%A7%DB%8C_%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647\u06cc \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u062f\u060c \u0628\u0647 \u062e\u0635\u0648\u0635 \u0628\u0631\u0627\u06cc \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Creating an index on the event_date column<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">INDEX<\/span> <span class=\"n\">idx_event_date<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">events<\/span><span class=\"p\">(<\/span><span class=\"n\">event_date<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B2_%D8%A7%D9%86%D9%88%D8%A7%D8%B9_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7%DB%8C_%D9%85%D9%86%D8%A7%D8%B3%D8%A8_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0646\u0627\u0633\u0628 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u06cc\u06a9\u067e\u0627\u0631\u0686\u06af\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc\u060c \u0647\u0645\u06cc\u0634\u0647 \u0627\u0632 \u0645\u0646\u0627\u0633\u0628 \u062a\u0631\u06cc\u0646 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Using DATE for date-only data<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">events<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">event_id<\/span> <span class=\"nb\">INT<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">event_date<\/span> <span class=\"nb\">DATE<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">event_name<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">100<\/span><span class=\"p\">)<\/span>\n<span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Using DATETIME for date and time data<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">appointments<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">appointment_id<\/span> <span class=\"nb\">INT<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">appointment_datetime<\/span> <span class=\"nb\">DATETIME<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">appointment_description<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">255<\/span><span class=\"p\">)<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%D8%AA%DB%8C%D8%AC%D9%87\"><\/span>\n<p>  \u0646\u062a\u06cc\u062c\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 SQL \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0627\u0634\u062f\u060c \u0627\u0645\u0627 \u062a\u0633\u0644\u0637 \u0628\u0631 \u0627\u06cc\u0646 \u0645\u0641\u0627\u0647\u06cc\u0645 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0648\u062b\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0627\u0633\u062a.  \u0628\u0627 \u062f\u0631\u06a9 \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0645\u062e\u062a\u0644\u0641 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0646\u0627\u0633\u0628 \u0645\u0646\u0627\u0637\u0642 \u0632\u0645\u0627\u0646\u06cc \u0648 \u067e\u06cc\u0631\u0648\u06cc \u0627\u0632 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06cc\u0648\u0647 \u0647\u0627\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0648\u062b\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f.  \u0686\u0647 \u062f\u0631 \u062d\u0627\u0644 \u0627\u0646\u062c\u0627\u0645 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0647\u0627\u06cc \u0633\u0627\u062f\u0647 \u062a\u0627\u0631\u06cc\u062e \u06cc\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0632\u0645\u0627\u0646 \u0628\u0627\u0634\u06cc\u062f\u060c \u0627\u06cc\u0646 \u0646\u06a9\u0627\u062a \u0648 \u062a\u0631\u0641\u0646\u062f\u0647\u0627 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u0628\u0627 \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062e\u0627\u0637\u0631 \u062f\u0631 \u067e\u06cc\u0686\u06cc\u062f\u06af\u06cc \u0647\u0627\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 SQL \u067e\u06cc\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u062f\u06cc\u0631\u06cc\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u06cc\u06a9 \u062c\u0646\u0628\u0647 \u062d\u06cc\u0627\u062a\u06cc \u0627\u0632 \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. SQL \u0627\u0646\u0648\u0627\u0639 \u062a\u0648\u0627\u0628\u0639 \u0648 \u062a\u06a9\u0646\u06cc\u06a9 \u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0627\u0631\u0622\u0645\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f. \u0686\u0647 \u0628\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0633\u0627\u062f\u0647 \u062a\u0627\u0631\u06cc\u062e \u0633\u0631 \u0648 \u06a9\u0627\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0648 \u0686\u0647 \u0628\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0632\u0645\u0627\u0646\u060c \u062f\u0631\u06a9 \u0646\u062d\u0648\u0647 \u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 SQL &hellip;<\/p>\n","protected":false},"author":2,"featured_media":67073,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-67072","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/67072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=67072"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/67072\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/67073"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=67072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=67072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=67072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}