{"id":41336,"date":"2019-12-27T08:57:43","date_gmt":"2019-12-27T05:27:43","guid":{"rendered":"https:\/\/ostovaee.ir\/fa\/?p=41336"},"modified":"2020-05-11T13:45:06","modified_gmt":"2020-05-11T09:15:06","slug":"%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql","status":"publish","type":"post","link":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/","title":{"rendered":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql"},"content":{"rendered":"\n<p>\u062f\u0631 \u0647\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062d\u062f\u0627\u0642\u0644 \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u0627\u0632 \u0646\u0648\u0639 \u062a\u0627\u0631\u06cc\u062e \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u062f\u0631 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f. \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0628\u0647 \u062a\u0627\u0631\u06cc\u062e \u0648 &#8230; \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0627 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0622\u0634\u0646\u0627 \u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u062f. \u0627\u0648\u0644\u06cc\u0646 \u0648 \u0645\u0647\u0645\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 Sql\u060c \u062f\u0633\u062a\u0648\u0631 Select \u0627\u0633\u062a \u0627\u06af\u0631 \u0628\u0627 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0646\u062f\u0627\u0631\u06cc\u062f \u0627\u0628\u062a\u062f\u0627 \u0622\u0645\u0648\u0632\u0634 <a href=\"https:\/\/ostovaee.ir\/fa\/%d8%af%d8%b3%d8%aa%d9%88%d8%b1-select-%d8%af%d8%b1-sql\/\">\u062f\u0633\u062a\u0648\u0631 Select<\/a> \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0634\u0631\u0637 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql<\/h2>\n\n\n\n<p>\u062f\u0631 sql \u0628\u0631\u0627\u06cc \u0641\u0644\u06cc\u062f\u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e \u062f\u0648\u0646\u0648\u0639 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06cc\u06a9\u06cc Date \u06a9\u0647 \u0641\u0642\u0637 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u062f\u06cc\u06af\u0631\u06cc Datetime \u0627\u0633\u062a \u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u0646\u06af\u0647 \u0645\u06cc\u200c\u062f\u0627\u0631\u062f. \u0627\u06af\u0631 \u0646\u0648\u0639 \u0641\u06cc\u0644\u062f \u0645\u0648\u0631\u062f\u0646\u0638\u0631 Date \u0628\u0627\u0634\u062f \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0628\u0647 \u0647\u0645\u0627\u0646 \u0635\u0648\u0631\u062a\u06cc\u06a9\u0647 \u0646\u0648\u0634\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc\u200c\u062f\u0647\u062f \u0627\u0645\u0627 \u0647\u0646\u06af\u0627\u0645\u06cc\u06a9\u0647 \u0628\u0627 \u0628\u062e\u0634 \u0632\u0645\u0627\u0646 \u0647\u0645 \u062f\u0631\u06af\u06cc\u0631 \u0647\u0633\u062a\u06cc\u062f \u062e\u0631\u0648\u062c\u06cc \u0627\u0646\u062f\u06a9\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0633\u062a.<\/p>\n\n\n\n<ul><li>\u062d\u0627\u0644\u062a \u0627\u0648\u0644: \u0641\u06cc\u0644\u062f \u0627\u0632 \u0646\u0648\u0639 \u062a\u0627\u0631\u06cc\u062e (Date) \u0627\u0633\u062a \u0648 \u0632\u0645\u0627\u0646 \u0646\u062f\u0627\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u062e\u0631\u0648\u062c\u06cc \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0634\u0627\u0645\u0644 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0641\u06cc\u0644\u062f ModifiedDate \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e &#8216;2018-03-21&#8217; \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u0641\u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e &#8220;2018-03-22&#8221; \u0628\u0647 \u0628\u0639\u062f \u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/li><\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select * \nfrom sales.salesorderdetail\nwhere ModifiedDate > '2018-03-21'<\/pre>\n\n\n\n<ul><li>\u062d\u0627\u0644\u062a \u062f\u0648\u0645: \u0641\u06cc\u0644\u062f \u0627\u0632 \u0646\u0648\u0639 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 (Datetime) \u0627\u0633\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u0627\u06af\u0631 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0646\u0648\u0634\u062a\u0647 \u0634\u0648\u062f \u06cc\u0639\u0646\u06cc \u062a\u0646\u0647\u0627  \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0646\u06a9\u0646\u06cc\u062f \u0628\u0635\u0648\u0631\u062a \u062e\u0648\u062f\u06a9\u0627\u0631 \u0632\u0645\u0627\u0646 \u0628\u0631\u0627\u0628\u0631 \u0635\u0641\u0631 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u062a\u0645\u0627\u0645 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e  &#8216;2018-03-21&#8217; \u0632\u0645\u0627\u0646 \u0622\u0646\u0647\u0627 \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 \u0635\u0641\u0631 \u0627\u0633\u062a \u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. <br>\u062f\u0631\u0635\u0648\u0631\u062a\u06cc\u06a9\u0647 \u0632\u0645\u0627\u0646 \u0631\u0627 \u062f\u0631 \u06a9\u0646\u0627\u0631 \u062a\u0627\u0631\u06cc\u062e \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 \u0622\u0646 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li><\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select * \nfrom sales.salesorderdetail\nwhere ModifiedDate > '2018-03-21 11:43:16.257'<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u062f\u0633\u062a\u0648\u0631 between \u062f\u0631 Sql \u0628\u0631\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e<\/h2>\n\n\n\n<p>\u0627\u0632 \u062f\u0633\u062a\u0648\u0631 between \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0628\u0627\u0632\u0647\u200c\u0627\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f \u0648 \u062d\u062a\u0645\u0627\u064b \u0628\u0627\u06cc\u062f \u062a\u0627\u0631\u06cc\u062e \u0634\u0631\u0648\u0639 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u067e\u0627\u06cc\u0627\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631 \u0628\u0627\u0634\u062f \u0648 \u06af\u0631\u0646\u0647 \u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u0631\u06a9\u0648\u0631\u062f\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select * \nfrom sales.salesorderdetail\nwhere ModifiedDate between  '2018-03-21 11:43:16.257' and '2018-04-10'<\/pre>\n\n\n\n<p>\u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u0641\u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0631\u0648\u0632 &#8216;2018-03-21&#8242; \u0627\u0632 \u0633\u0627\u0639\u062a &#8217;11:43:16.257&#8217; \u0628\u0647 \u0628\u0639\u062f \u062a\u0627 \u0632\u0645\u0627\u0646 \u0635\u0641\u0631 \u062a\u0627\u0631\u06cc\u062e &#8216;2018-04-10&#8217; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u06cc\u0639\u0646\u06cc \u0641\u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0631\u0648\u0632 &#8216;2018-04-10&#8217; \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ostovaee.ir\/fa\/product\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%b1%d8%a7%db%8c%da%af%d8%a7%d9%86-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"953\" height=\"278\" src=\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-FreeStart.jpg\" alt=\"\u0622\u0645\u0648\u0632\u0634 \u0631\u0627\u06cc\u06af\u0627\u0646 Sql Server | \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\" class=\"wp-image-1375\" srcset=\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-FreeStart.jpg 953w, https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-FreeStart-300x88.jpg 300w, https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-FreeStart-768x224.jpg 768w, https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-FreeStart-500x146.jpg 500w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u062f\u0631\u06cc\u0627\u0641\u062a \u062a\u0627\u0631\u06cc\u062e \u0631\u0648\u0632 \u062f\u0631 Sql<\/h2>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u062a\u0627\u0631\u06cc\u062e \u0631\u0648\u0632 \u062f\u0631 sql \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0628\u0646\u0627\u0645 getdate \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062c\u0627\u0631\u06cc \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f. \u062a\u0627\u0628\u0639 getdate\u060c \u06cc\u06a9\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql \u0627\u0633\u062a.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select getdate()  \u062e\u0631\u0648\u062c\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062c\u0627\u0631\u06cc \u0628\u0637\u0648\u0631\u0645\u062b\u0627\u0644 \"2019-12-14 11:55:43.333\" \u0627\u0633\u062a<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0627\u0628\u0639 datepart \u062f\u0631 Sql<\/h2>\n\n\n\n<p>\u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u06cc\u06a9\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.  \u0628\u0627 \u06a9\u0645\u06a9 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0633\u0627\u0644\u060c \u0645\u0627\u0647\u060c \u0631\u0648\u0632\u060c \u0647\u0641\u062a\u0647\u060c \u0686\u0646\u062f\u0645\u06cc\u0646 \u0631\u0648\u0632 \u0633\u0627\u0644\u060c \u0686\u0646\u062f\u0645\u06cc\u0646 \u0631\u0648\u0632 \u0647\u0641\u062a\u0647\u060c \u0633\u0627\u0639\u062a\u060c \u062f\u0642\u06cc\u0642\u0647\u060c \u062b\u0627\u0646\u06cc\u0647 \u0648 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u062f\u0627\u0631\u0627\u06cc \u062f\u0648 \u0648\u0631\u0648\u062f\u06cc \u0645\u06cc\u200c\u0628\u0627\u0634\u062f \u0627\u0648\u0644\u06cc\u0646 \u0648\u0631\u0648\u062f\u06cc \u0646\u0648\u0639 \u062e\u0631\u0648\u062c\u06cc \u0648 \u062f\u0648\u0645\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0627\u0633\u062a. \u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 Int (\u0639\u062f\u062f) \u0627\u0633\u062a.<\/p>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0633\u0627\u0644 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 year\u060c yy\u060c yyyy \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f. <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(year,'2018-03-21 11:43:16.257')   \u062e\u0631\u0648\u062c\u06cc 2018 \u0627\u0633\u062a\nselect datepart(yy,getdate())  \u062e\u0631\u0648\u062c\u06cc \u0633\u0627\u0644 \u062a\u0627\u0631\u06cc\u062e \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p> \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u0627\u0647 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 m\u060c mm\u060c month \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.  <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(month,'2018-03-21')   \u062e\u0631\u0648\u062c\u06cc 3 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f\nselect datepart(mm,getdate())    \u062e\u0631\u0648\u062c\u06cc \u0645\u0627\u0647 \u062a\u0627\u0631\u06cc\u062e \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0641\u0635\u0644 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 q\u060c qq \u060cquarter \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.   <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(QUARTER,'2018-03-21')  \u062e\u0631\u0648\u062c\u06cc 1 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u0627\u0648\u0644\u06cc\u0646 \u0641\u0635\u0644 \u0633\u0627\u0644\nselect datepart(QQ,getdate())  \u062e\u0631\u0648\u062c\u06cc \u0641\u0635\u0644 \u062a\u0627\u0631\u06cc\u062e \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0631\u0648\u0632 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 d\u060c dd\u060cDay \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.    <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(DAY,'2018-03-21') \u062e\u0631\u0648\u062c\u06cc 21 \u0627\u0633\u062a \nselect datepart(dd,getdate())   \u062e\u0631\u0648\u062c\u06cc \u0631\u0648\u0632 \u062a\u0627\u0631\u06cc\u062e \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p> \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u06cc\u0646\u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u0686\u0646\u062f\u0645\u06cc\u0646 \u0631\u0648\u0632 \u0633\u0627\u0644 \u0627\u0633\u062a \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 dayofyear \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.     <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(DAYOFYEAR,'1398\/09\/23 11:43:16.257') \u062e\u0631\u0648\u062c\u06cc 266 \u0627\u0633\u062a<\/pre>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u06cc\u0646\u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u0686\u0646\u062f\u0645\u06cc\u0646 \u0647\u0641\u062a\u0647 \u0633\u0627\u0644 \u0627\u0633\u062a \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 wk\u060c ww\u060cWeek \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.  <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(WEEK,'2018-03-21')   \u062e\u0631\u0648\u062c\u06cc 12 \u0627\u0633\u062a\nselect datepart(ww,getdate())<\/pre>\n\n\n\n<p> \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u06cc\u0646\u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u0686\u0646\u062f\u0645\u06cc\u0646 \u0631\u0648\u0632 \u0647\u0641\u062a\u0647 \u0627\u0633\u062a \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 w\u060c dw\u060cWeekday \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.   <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(WEEKDAY,'1398\/09\/23')  \u062e\u0631\u0648\u062c\u06cc 1 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u0627\u0648\u0644\u06cc\u0646 \u0631\u0648\u0632 \u0647\u0641\u062a\u0647\nselect datepart(DW,getdate())<\/pre>\n\n\n\n<p>\u0633\u0627\u0644\u060c \u0645\u0627\u0647 \u0648 \u0631\u0648\u0632 \u0631\u0627 \u0628\u062c\u0632 \u062a\u0627\u0628\u0639 datepart \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0627 \u06a9\u0645\u06a9 \u062a\u0648\u0627\u0628\u0639 year\u060c month \u0648 day \u0628\u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select year(getdate())\nselect month('1398\/09\/23 11:43:16.257')\nselect day('2018-03-21 11:43:16.257')<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u062a\u0627\u0628\u0639 \u0632\u0645\u0627\u0646 \u062f\u0631 sql<\/h3>\n\n\n\n<p> \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\u060c \u062a\u0627\u0628\u0639 \u0632\u0645\u0627\u0646 \u062f\u0631 sql \u0646\u06cc\u0632 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0633\u0627\u0639\u062a \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 h\u060c hh\u060chour \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.   <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(HOUR,'1398\/09\/23 11:43:16.257')  \u062e\u0631\u0648\u062c\u06cc \u0633\u0627\u0639\u062a 11 \u0627\u0633\u062a\nselect datepart(HH,getdate())  \u062e\u0631\u0648\u062c\u06cc \u0633\u0627\u0639\u062a \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p>  \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u062f\u0642\u06cc\u0642\u0647 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 n\u060c mi\u060cMinute \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.   <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(MINUTE,'1398\/09\/23 11:43:16.257')  \u062e\u0631\u0648\u062c\u06cc \u062f\u0642\u06cc\u0642\u0647 43 \u0627\u0633\u062a\nselect datepart(mi,getdate())  \u062e\u0631\u0648\u062c\u06cc \u062f\u0642\u06cc\u0642\u0647 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p> \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u062b\u0627\u0646\u06cc\u0647 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 s\u060c ss\u060cSecond \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.    <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(SECOND,'1398\/09\/23 11:43:16.257')  \u062e\u0631\u0648\u062c\u06cc \u062b\u0627\u0646\u06cc\u0647 16 \u0627\u0633\u062a\nselect datepart(s,getdate())  \u062e\u0631\u0648\u062c\u06cc \u062b\u0627\u0646\u06cc\u0647 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u062c\u0627\u0631\u06cc \u0627\u0633\u062a<\/pre>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u0648\u0644 \u0631\u0627 ms\u060cMillisecond \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0631\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0645\u06cc\u0644\u0627\u062f\u06cc \u06cc\u0627 \u0634\u0645\u0633\u06cc \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.   <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datepart(MILLISECOND,'1398\/09\/23 11:43:16.257') \u062e\u0631\u0648\u062c\u06cc 257 \u0645\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0627\u0633\u062a\nselect datepart(MS,getdate())<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ostovaee.ir\/fa\/product\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%da%a9%d8%a7%d9%85%d9%84-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"953\" height=\"358\" src=\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-Magic-Feature.jpg\" alt=\"\u062c\u0627\u062f\u0648\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc Sql Server |\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\" class=\"wp-image-1378\" srcset=\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-Magic-Feature.jpg 953w, https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-Magic-Feature-300x113.jpg 300w, https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-Magic-Feature-768x289.jpg 768w, https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/04\/SQL-Adver-Magic-Feature-500x188.jpg 500w\" sizes=\"(max-width: 953px) 100vw, 953px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0627\u0628\u0639 \u0627\u062e\u062a\u0644\u0627\u0641 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql<\/h2>\n\n\n\n<p>\u06cc\u06a9\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\u060c \u062a\u0627\u0628\u0639  Datediff  \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627 \u06a9\u0645\u06a9 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u062e\u062a\u0644\u0627\u0641 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f. \u0627\u0648\u0644\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0647\u0645\u0627\u0646\u0646\u062f \u062a\u0627\u0628\u0639 Datepart \u0645\u0634\u062e\u0635 \u06a9\u0646\u0646\u062f\u0647 \u0646\u0648\u0639 \u062e\u0631\u0648\u062c\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u0627\u0644 (year | yy)\u060c \u0645\u0627\u0647 ( month | mm)\u060c \u0631\u0648\u0632 (day | dd)\u060c \u0633\u0627\u0639\u062a (hour | hh)\u060c \u062f\u0642\u06cc\u0642\u0647 (minute | mi)\u060c \u062b\u0627\u0646\u06cc\u0647 (second | ss) \u0648 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 (millisecond | ms) \u0627\u0633\u062a. \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u062a\u0627\u0631\u06cc\u062e \u0634\u0631\u0648\u0639 \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0633\u0648\u0645 \u062a\u0627\u0631\u06cc\u062e \u067e\u0627\u06cc\u0627\u0646 \u0627\u0633\u062a. <br>\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0627\u06af\u0631 \u062a\u0627\u0631\u06cc\u062e \u067e\u0627\u06cc\u0627\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0634\u0631\u0648\u0639 \u0628\u0627\u0634\u062f \u062e\u0631\u0648\u062c\u06cc \u0639\u062f\u062f\u06cc \u0645\u0646\u0641\u06cc \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select datediff(day,'1398\/06\/01','1398\/06\/30') \u062e\u0631\u0648\u062c\u06cc 29 \u0627\u0633\u062a\nselect datediff(MONTH,'1398\/06\/01','1398\/06\/30') \u062e\u0631\u0648\u062c\u06cc \u0635\u0641\u0631 \u0627\u0633\u062a\nselect datediff(YEAR,'1397\/06\/01','1398\/06\/30') \u062e\u0631\u0648\u062c\u06cc \u06cc\u06a9 \u0627\u0633\u062a\nselect datediff(hour,'1398\/06\/01','1398\/06\/02 11:43:16.257') \u062e\u0631\u0648\u062c\u06cc 35 \u0627\u0633\u062a\nselect datediff(MINUTE,'1398\/06\/01','1398\/06\/02 11:43:16.257') \u062e\u0631\u0648\u062c\u06cc 2143 \u0627\u0633\u062a\nselect datediff(SECOND,'1398\/06\/01','1398\/06\/02 11:43:16.257') \u062e\u0631\u0648\u062c\u06cc 128596 \u0627\u0633\u062a\nselect datediff(MILLISECOND,'1398\/06\/02','1398\/06\/02 00:00:01.257') \u062e\u0631\u0648\u062c\u06cc 1257 \u0627\u0633\u062a\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0627\u0628\u0639 dateadd \u062f\u0631 Sql<\/h2>\n\n\n\n<p>\u06cc\u06a9\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\u060c \u062a\u0627\u0628\u0639 dateadd \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u06a9\u0645\u06a9 \u0622\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0627\u0635\u0644\u0647 \u0632\u0645\u0627\u0646\u06cc \u0645\u0634\u062e\u0635 \u0631\u0627 \u0628\u0647 \u062a\u0627\u0631\u06cc\u062e \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0627\u0636\u0627\u0641\u0647 \u06cc\u0627 \u06a9\u0645 \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0633\u0647 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f \u0627\u0648\u0644\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647  \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u0627\u0644 (year | yy)\u060c \u0645\u0627\u0647 ( month | mm)\u060c \u0631\u0648\u0632 (day | dd)\u060c \u0633\u0627\u0639\u062a (hour | hh)\u060c \u062f\u0642\u06cc\u0642\u0647 (minute | mi)\u060c \u062b\u0627\u0646\u06cc\u0647 (second | ss) \u0648 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 (millisecond | ms) \u062a\u0627\u0631\u06cc\u062e \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0627\u0636\u0627\u0641\u0647 \u06cc\u0627 \u06a9\u0645 \u0634\u0648\u062f. \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u062f\u0648\u0645 \u06cc\u06a9 \u0639\u062f\u062f \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc\u0632\u0627\u0646 \u0627\u0641\u0632\u0627\u06cc\u0634 \u06cc\u0627 \u06a9\u0627\u0647\u0634 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0633\u0648\u0645 \u062a\u0627\u0631\u06cc\u062e \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0627\u0633\u062a. \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u062f\u0631 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0627\u06cc\u062f \u062d\u062a\u0645\u0627\u064b \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648\u0631\u0648\u062f\u06cc \u0633\u0648\u0645 \u06cc\u06a9 \u062a\u0627\u0631\u06cc\u062e \u0645\u06cc\u0644\u0627\u062f\u06cc \u0628\u0627\u0634\u062f \u0648 \u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u062a\u0627\u0631\u06cc\u062e \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0639\u062f\u062f\u06cc \u0645\u062b\u0628\u062a \u0628\u0627\u0634\u062f \u0648 \u06a9\u0627\u0647\u0634 \u062a\u0627\u0631\u06cc\u062e \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u062f\u0648\u0645 \u0639\u062f\u062f\u06cc \u0645\u0646\u0641\u06cc \u0628\u0627\u0634\u062f<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select DATEADD(YEAR,1,'2018-12-15 09:17:15.297')\n\u062e\u0631\u0648\u062c\u06cc 2019-12-15 09:17:15.297 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u06cc\u06a9\u0633\u0627\u0644 \u0628\u0647 \u062a\u0627\u0631\u06cc\u062e \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\n\nselect DATEADD(YEAR,-1,'2018-12-15 09:17:15.297') \n\u062e\u0631\u0648\u062c\u06cc 2017-12-15 09:17:15.297 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u06cc\u06a9\u0633\u0627\u0644 \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u06a9\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f\n\nselect DATEADD(MONTH,1,'2018-12-15 09:17:15.297') \n\u062e\u0631\u0648\u062c\u06cc 2019-01-15 09:17:15.297 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u06cc\u06a9 \u0645\u0627\u0647 \u0628\u0647 \u062a\u0627\u0631\u06cc\u062e \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\n\nselect DATEADD(day,5,'2018-12-15 09:17:15.297') \n\u062e\u0631\u0648\u062c\u06cc 2018-12-20 09:17:15.297 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc 5 \u0631\u0648\u0632 \u0628\u0647 \u062a\u0627\u0631\u06cc\u062e \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\n\nselect DATEADD(HOUR,2,'2018-12-15 09:17:15.297') \n\u062e\u0631\u0648\u062c\u06cc 2018-12-15 11:17:15.297 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc 2 \u0633\u0627\u0639\u062a \u0628\u0647 \u0632\u0645\u0627\u0646 \u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\n\nselect DATEADD(MINUTE,13,'2018-12-15 09:17:15.297') \n\u062e\u0631\u0648\u062c\u06cc 2018-12-15 09:30:15.297 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc 13 \u062f\u0642\u06cc\u0642\u0647 \u0628\u0647 \u0632\u0645\u0627\u0646 \u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\n\nselect DATEADD(SECOND,10,getdate()) \n\u062e\u0631\u0648\u062c\u06cc 10 \u062b\u0627\u0646\u06cc\u0647 \u0628\u0647 \u0632\u0645\u0627\u0646 \u062c\u0627\u0631\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f\n\nselect DATEADD(MILLISECOND,-200,'2018-12-15 09:17:15.297') \n\u062e\u0631\u0648\u062c\u06cc 2018-12-15 09:17:15.097 \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc 200 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0627\u0632 \u0632\u0645\u0627\u0646 \u06a9\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u0633\u0631\u0641\u0635\u0644\u200c\u0647\u0627\u06cc \u0622\u0645\u0648\u0632\u0634 Sql<\/h2>\n\n\n\n<div class=\"list\">\n    <ul>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=37911\"><span class=\"hide-icon\"><i class=\"fa fa-play text-free\"><\/i><\/span><span class=\"number text-free\"> 01<\/span> <span class=\"list-content\"><span class=\"list-cat\"> Sql Server<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u0646\u0635\u0628 Sql Server 2014 <\/span><\/span> <span class=\"list-tag tag-free\">\u0631\u0627\u06cc\u06af\u0627\u0646<\/span> <span style=\"float:left;\"> <span class=\"list-time\">05:14<\/span> <i class=\"fa fa-download text-free\"><\/i><\/span><\/a><\/li>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=37920\"><span class=\"hide-icon\"><i class=\"fa fa-play text-free\"><\/i><\/span><span class=\"number text-free\"> 02<\/span> <span class=\"list-content\"><span class=\"list-cat\"> Sql Server<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u0622\u0645\u0648\u0632\u0634 Sql Server <\/span><\/span> <span class=\"list-tag tag-free\">\u0631\u0627\u06cc\u06af\u0627\u0646<\/span> <span style=\"float:left;\"> <span class=\"list-time\">05:47<\/span> <i class=\"fa fa-download text-free\"><\/i><\/span><\/a><\/li>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=37912\"><span class=\"hide-icon\"><i class=\"fa fa-play text-free\"><\/i><\/span><span class=\"number text-free\"> 03<\/span> <span class=\"list-content\"><span class=\"list-cat\"> Sql Server<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u062f\u0633\u062a\u0648\u0631 Select \u062f\u0631 Sql <\/span><\/span> <span class=\"list-tag tag-free\">\u0631\u0627\u06cc\u06af\u0627\u0646<\/span> <span style=\"float:left;\"> <span class=\"list-time\">06:52<\/span> <i class=\"fa fa-download text-free\"><\/i><\/span><\/a><\/li>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=37913\"><span class=\"hide-icon\"><i class=\"fa fa-play text-free\"><\/i><\/span><span class=\"number text-free\"> 04<\/span> <span class=\"list-content\"><span class=\"list-cat\"> Sql Server<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u062f\u0633\u062a\u0648\u0631 Where \u062f\u0631 Sql <\/span><\/span> <span class=\"list-tag tag-free\">\u0631\u0627\u06cc\u06af\u0627\u0646<\/span> <span style=\"float:left;\"> <span class=\"list-time\">08:12<\/span> <i class=\"fa fa-download text-free\"><\/i><\/span><\/a><\/li>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=887\"><span class=\"hide-icon\"><i class=\"fa fa-play text-free\"><\/i><\/span><span class=\"number text-free\"> 05<\/span> <span class=\"list-content\"><span class=\"list-cat\"> Sql Server<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u0639\u0645\u0644\u06af\u0631 Like \u062f\u0631 Sql <\/span><\/span> <span class=\"list-tag tag-free\">\u0631\u0627\u06cc\u06af\u0627\u0646<\/span> <span style=\"float:left;\"> <span class=\"list-time\">09:42<\/span> <i class=\"fa fa-download text-free\"><\/i><\/span><\/a><\/li>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=897\"><span class=\"hide-icon\"><i class=\"fa fa-play text-free\"><\/i><\/span><span class=\"number text-free\"> 06<\/span> <span class=\"list-content\"><span class=\"list-cat\"> Sql Server<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u062f\u0633\u062a\u0648\u0631 Order By \u062f\u0631 Sql <\/span><\/span> <span class=\"list-tag tag-free\">\u0631\u0627\u06cc\u06af\u0627\u0646<\/span> <span style=\"float:left;\"> <span class=\"list-time\">07:07<\/span> <i class=\"fa fa-download text-free\"><\/i><\/span><\/a><\/li>\n\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=30922\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"hide-icon\"><i class=\"fa fa-user text-user\"><\/i> <\/span><span class=\"number text-user\">07<\/span><span class=\"list-content\"><span class=\"list-cat\">\u0648\u06cc\u062a\u0627\u0645\u06cc\u0646 \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc<\/span><span class=\"red-dash\"> | <\/span><span class=\"list-description\"> \u0622\u0645\u0648\u0632\u0634 \u0631\u0627\u06cc\u06af\u0627\u0646 Sql Server<\/span><\/span> <span class=\"list-tag tag-user\">\u0639\u0636\u0648\u06cc\u062a<\/span> <span style=\"float:left;\"><span class=\"list-time\">7 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634\u06cc<\/span><i class=\"fa fa-lock text-user\"><\/i><\/span><\/a><\/li>\n        <li><a href=\"https:\/\/ostovaee.ir\/fa\/?p=30949\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"hide-icon\"><i class=\"fa fa-close text-prof\"><\/i><\/span><span class=\"number text-prof\">08<\/span><span class=\"list-content\"> <span class=\"list-cat\">\u062c\u0627\u062f\u0648\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc<\/span><span class=\"red-dash\"> |  <\/span><span class=\"list-description\"> \u0622\u0645\u0648\u0632\u0634 \u06a9\u0627\u0645\u0644 Sql Server <\/span><\/span> <span class=\"list-tag tag-prof\">\u062e\u0631\u06cc\u062f<\/span> <span style=\"float:left;\"> <span class=\"list-time\"> 41 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634\u06cc <\/span> <i class=\"fa fa-lock text-prof\"><\/i><\/span><\/a><\/li>\n    <\/ul>\n<\/div>\n<footer class=\"author_bio_section\" ><div class=\"author_details row\"><div class=\"col-sm-2\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/7efd2bff7ccd8c87b70e411c8b152b5e?s=150&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/7efd2bff7ccd8c87b70e411c8b152b5e?s=300&#038;d=mm&#038;r=g 2x' class='avatar avatar-150 photo' height='150' width='150' loading='lazy' decoding='async'\/><\/div><div class=\"col-sm-10\"><h4 class=\"author_name\">\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc<\/h4><p>\u062f\u0627\u0646\u0634 \u0622\u0645\u0648\u062e\u062a\u0647 \u0645\u0647\u0646\u062f\u0633\u06cc \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 - \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u060c \u0639\u0644\u0627\u0642\u0645\u0646\u062f \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633<\/p><\/div><\/div><hr class=\"mt-0\"><a class=\"btn btn-info btn-sm mr-2\" href=\"https:\/\/ostovaee.ir\/fa\/author\/roni\/\">\u0645\u0642\u0627\u0644\u0647\u200c\u0647\u0627\u06cc \u0645\u0646 (18)<\/a><a class=\"btn btn-info btn-sm\"  href=\"https:\/\/ostovaee.ir\/fa\/author-products\/roni\">\u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0645\u0646 (2)<\/a><\/footer>","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u0647\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062d\u062f\u0627\u0642\u0644 \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u0627\u0632 \u0646\u0648\u0639 \u062a\u0627\u0631\u06cc\u062e \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0644\u0627\u0632\u0645 \u0627\u0633\u062a [&hellip;]<\/p>\n","protected":false},"author":507,"featured_media":41762,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[86],"tags":[204,201,200,202],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v20.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634 \u06a9\u0627\u0631 \u0628\u0627 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 Date \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc<\/title>\n<meta name=\"description\" content=\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0648 ... \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ostovaee.ir\/fa\/\u062a\u0648\u0627\u0628\u0639-\u062a\u0627\u0631\u06cc\u062e\u06cc-\u062f\u0631-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\" \/>\n<meta property=\"og:description\" content=\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0648 ... \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ostovaee.ir\/fa\/\u062a\u0648\u0627\u0628\u0639-\u062a\u0627\u0631\u06cc\u062e\u06cc-\u062f\u0631-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-27T05:27:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-11T09:15:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/12\/Date-Time-Sql-Ostovaee-\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"953\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/\"},\"author\":{\"name\":\"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/#\/schema\/person\/f83b494f3278368416b009bc35cd2264\"},\"headline\":\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\",\"datePublished\":\"2019-12-27T05:27:43+00:00\",\"dateModified\":\"2020-05-11T09:15:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/\"},\"wordCount\":124,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/#organization\"},\"keywords\":[\"\u0627\u062e\u062a\u0644\u0627\u0641 \u062f\u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 sql\",\"\u062a\u0627\u0628\u0639 dateadd \u062f\u0631 sql\",\"\u062a\u0627\u0628\u0639 datepart \u062f\u0631 sql\",\"\u062a\u0627\u0628\u0639 \u0627\u062e\u062a\u0644\u0627\u0641 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\"],\"articleSection\":[\"Microsoft Sql Server\"],\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/\",\"url\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/\",\"name\":\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634 \u06a9\u0627\u0631 \u0628\u0627 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 Date \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\",\"isPartOf\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/#website\"},\"datePublished\":\"2019-12-27T05:27:43+00:00\",\"dateModified\":\"2020-05-11T09:15:06+00:00\",\"description\":\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0648 ... \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.\",\"breadcrumb\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\/\/ostovaee.ir\/fa\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Sql Server\",\"item\":\"https:\/\/ostovaee.ir\/fa\/category\/microsoft-sql-server\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/#website\",\"url\":\"https:\/\/ostovaee.ir\/fa\/\",\"name\":\"\u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\",\"description\":\"\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc | \u062a\u062c\u0631\u0628\u0647 \u06cc\u06a9 \u062d\u0633 \u0631\u0648\u06cc\u0627\u06cc\u06cc \u0628\u0627 \u0622\u0645\u0648\u0632\u0634 \u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\",\"publisher\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ostovaee.ir\/fa\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/#organization\",\"name\":\"\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\",\"url\":\"https:\/\/ostovaee.ir\/fa\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/06\/Ostovaee-Logo-play.png\",\"contentUrl\":\"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/06\/Ostovaee-Logo-play.png\",\"width\":245,\"height\":245,\"caption\":\"\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc\"},\"image\":{\"@id\":\"https:\/\/ostovaee.ir\/fa\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/#\/schema\/person\/f83b494f3278368416b009bc35cd2264\",\"name\":\"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/ostovaee.ir\/fa\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7efd2bff7ccd8c87b70e411c8b152b5e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7efd2bff7ccd8c87b70e411c8b152b5e?s=96&d=mm&r=g\",\"caption\":\"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc\"},\"description\":\"\u062f\u0627\u0646\u0634 \u0622\u0645\u0648\u062e\u062a\u0647 \u0645\u0647\u0646\u062f\u0633\u06cc \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 - \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u060c \u0639\u0644\u0627\u0642\u0645\u0646\u062f \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\",\"url\":\"https:\/\/ostovaee.ir\/fa\/author\/roni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634 \u06a9\u0627\u0631 \u0628\u0627 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 Date \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc","description":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0648 ... \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ostovaee.ir\/fa\/\u062a\u0648\u0627\u0628\u0639-\u062a\u0627\u0631\u06cc\u062e\u06cc-\u062f\u0631-sql\/","og_locale":"fa_IR","og_type":"article","og_title":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql","og_description":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0648 ... \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.","og_url":"https:\/\/ostovaee.ir\/fa\/\u062a\u0648\u0627\u0628\u0639-\u062a\u0627\u0631\u06cc\u062e\u06cc-\u062f\u0631-sql\/","og_site_name":"\u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc","article_published_time":"2019-12-27T05:27:43+00:00","article_modified_time":"2020-05-11T09:15:06+00:00","og_image":[{"width":953,"height":300,"url":"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/12\/Date-Time-Sql-Ostovaee-\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc.jpg","type":"image\/jpeg"}],"author":"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc","twitter_card":"summary_large_image","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"2 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#article","isPartOf":{"@id":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/"},"author":{"name":"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc","@id":"https:\/\/ostovaee.ir\/fa\/#\/schema\/person\/f83b494f3278368416b009bc35cd2264"},"headline":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql","datePublished":"2019-12-27T05:27:43+00:00","dateModified":"2020-05-11T09:15:06+00:00","mainEntityOfPage":{"@id":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/"},"wordCount":124,"commentCount":6,"publisher":{"@id":"https:\/\/ostovaee.ir\/fa\/#organization"},"keywords":["\u0627\u062e\u062a\u0644\u0627\u0641 \u062f\u0648 \u0632\u0645\u0627\u0646 \u062f\u0631 sql","\u062a\u0627\u0628\u0639 dateadd \u062f\u0631 sql","\u062a\u0627\u0628\u0639 datepart \u062f\u0631 sql","\u062a\u0627\u0628\u0639 \u0627\u062e\u062a\u0644\u0627\u0641 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql"],"articleSection":["Microsoft Sql Server"],"inLanguage":"fa-IR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/","url":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/","name":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634 \u06a9\u0627\u0631 \u0628\u0627 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 Date \u062f\u0631 Sql | \u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc","isPartOf":{"@id":"https:\/\/ostovaee.ir\/fa\/#website"},"datePublished":"2019-12-27T05:27:43+00:00","dateModified":"2020-05-11T09:15:06+00:00","description":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql | \u062f\u0631sql\u060c \u0686\u0646\u062f \u062a\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0631\u0627\u062d\u062a\u062a\u0631 \u0628\u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0641\u0627\u0636\u0644 \u062f\u0648 \u062a\u0627\u0631\u06cc\u062e\u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u062e\u0634\u06cc \u0627\u0632 \u062a\u0627\u0631\u06cc\u062e \u0648 ... \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.","breadcrumb":{"@id":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ostovaee.ir\/fa\/%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d8%aa%d8%a7%d8%b1%db%8c%d8%ae%db%8c-%d8%af%d8%b1-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/ostovaee.ir\/fa\/"},{"@type":"ListItem","position":2,"name":"Microsoft Sql Server","item":"https:\/\/ostovaee.ir\/fa\/category\/microsoft-sql-server\/"},{"@type":"ListItem","position":3,"name":"\u062a\u0648\u0627\u0628\u0639 \u062a\u0627\u0631\u06cc\u062e \u062f\u0631 Sql"}]},{"@type":"WebSite","@id":"https:\/\/ostovaee.ir\/fa\/#website","url":"https:\/\/ostovaee.ir\/fa\/","name":"\u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc","description":"\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc | \u062a\u062c\u0631\u0628\u0647 \u06cc\u06a9 \u062d\u0633 \u0631\u0648\u06cc\u0627\u06cc\u06cc \u0628\u0627 \u0622\u0645\u0648\u0632\u0634 \u0647\u0627\u06cc \u0627\u0633\u062a\u0648\u0627\u06cc\u06cc","publisher":{"@id":"https:\/\/ostovaee.ir\/fa\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ostovaee.ir\/fa\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fa-IR"},{"@type":"Organization","@id":"https:\/\/ostovaee.ir\/fa\/#organization","name":"\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc","url":"https:\/\/ostovaee.ir\/fa\/","logo":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/ostovaee.ir\/fa\/#\/schema\/logo\/image\/","url":"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/06\/Ostovaee-Logo-play.png","contentUrl":"https:\/\/ostovaee.ir\/fa\/wp-content\/uploads\/2019\/06\/Ostovaee-Logo-play.png","width":245,"height":245,"caption":"\u0627\u0633\u062a\u0648\u0627\u06cc\u06cc"},"image":{"@id":"https:\/\/ostovaee.ir\/fa\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ostovaee.ir\/fa\/#\/schema\/person\/f83b494f3278368416b009bc35cd2264","name":"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/ostovaee.ir\/fa\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7efd2bff7ccd8c87b70e411c8b152b5e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7efd2bff7ccd8c87b70e411c8b152b5e?s=96&d=mm&r=g","caption":"\u0631\u0648\u0646\u0627\u06a9 \u062d\u06cc\u0627\u062a \u063a\u06cc\u0628\u06cc"},"description":"\u062f\u0627\u0646\u0634 \u0622\u0645\u0648\u062e\u062a\u0647 \u0645\u0647\u0646\u062f\u0633\u06cc \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 - \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u060c \u0639\u0644\u0627\u0642\u0645\u0646\u062f \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633","url":"https:\/\/ostovaee.ir\/fa\/author\/roni\/"}]}},"views":19994,"_links":{"self":[{"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/posts\/41336"}],"collection":[{"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/users\/507"}],"replies":[{"embeddable":true,"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/comments?post=41336"}],"version-history":[{"count":0,"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/posts\/41336\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/media\/41762"}],"wp:attachment":[{"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/media?parent=41336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/categories?post=41336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ostovaee.ir\/fa\/wp-json\/wp\/v2\/tags?post=41336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}