{"id":798,"date":"2021-07-08T08:10:30","date_gmt":"2021-07-08T08:10:30","guid":{"rendered":"https:\/\/www.bearloga.space\/?page_id=798"},"modified":"2021-07-08T08:27:02","modified_gmt":"2021-07-08T08:27:02","slug":"funkczii-dlya-raboty-s-datami-i-vremenem","status":"publish","type":"page","link":"https:\/\/www.bearloga.space\/uk\/funkczii-dlya-raboty-s-datami-i-vremenem\/","title":{"rendered":"\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">MySQL \u0438\u043c\u0435\u0435\u0442 \u0440\u044f\u0434 \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u0442\u044b \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0424\u0443\u043d\u043a\u0446\u0438\u0438&nbsp;<strong>NOW()<\/strong>,&nbsp;<strong>SYSDATE()<\/strong>,&nbsp;<strong>CURRENT_TIMESTAMP()<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u0443\u044e \u0434\u0430\u0442\u0443 \u0438 \u0432\u0440\u0435\u043c\u044f \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0445 \u0447\u0430\u0441\u043e\u0432 \u0432 \u0432\u0438\u0434\u0435 \u043e\u0431\u044a\u0435\u043a\u0442\u0430 datetime. \u0412\u0441\u0435 \u0442\u0440\u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u044b\u0439 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442123<code>SELECT<\/code> <code>NOW();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 2018-05-25 21:34:55<\/code><code>SELECT<\/code> <code>SYSDATE();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 2018-05-25 21:34:55<\/code><code>SELECT<\/code> <code>CURRENT_TIMESTAMP<\/code><code>(); <\/code><code>-- 2018-05-25 21:32:55<\/code><\/li><li>\u0424\u0443\u043d\u043a\u0446\u0438\u0438&nbsp;<strong>CURDATE<\/strong>&nbsp;\u0438&nbsp;<strong>CURRENT_DATE<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u0443\u044e \u0434\u0430\u0442\u0443 \u0432 \u0432\u0438\u0434\u0435 \u043e\u0431\u044a\u0435\u043a\u0442\u0430 date:12<code>SELECT<\/code> <code>CURRENT_DATE<\/code><code>();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 2018-05-25<\/code><code>SELECT<\/code> <code>CURDATE();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 2018-05-25<\/code><\/li><li>\u0424\u0443\u043d\u043a\u0446\u0438\u0438&nbsp;<strong>CURTIME<\/strong>&nbsp;\u0438&nbsp;<strong>CURRENT_TIME<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u0442\u0435\u043a\u0443\u0449\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u0432 \u0432\u0438\u0434\u0435 \u043e\u0431\u044a\u0435\u043a\u0442\u0430 time:12<code>SELECT<\/code> <code>CURRENT_TIME<\/code><code>();&nbsp; <\/code><code>-- 20:47:45<\/code><code>SELECT<\/code> <code>CURTIME();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 20:47:45<\/code><\/li><li><strong>UTC_DATE<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u0443\u044e \u0434\u0430\u0442\u0443 \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e GMT1<code>SELECT<\/code> <code>UTC_DATE();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 2018-05-25<\/code><\/li><li><strong>UTC_TIME<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0442\u0435\u043a\u0443\u0449\u0435\u0435 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e GMT1<code>SELECT<\/code> <code>UTC_TIME();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/code><code>-- 17:47:45<\/code><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u041f\u0430\u0440\u0441\u0438\u043d\u0433 \u0434\u0430\u0442\u044b \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>DAYOFMONTH(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0434\u0435\u043d\u044c \u043c\u0435\u0441\u044f\u0446\u0430 \u0432 \u0432\u0438\u0434\u0435 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/li><li><strong>DAYOFWEEK(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0434\u0435\u043d\u044c \u043d\u0435\u0434\u0435\u043b\u0438 \u0432 \u0432\u0438\u0434\u0435 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/li><li><strong>DAYOFYEAR(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043d\u043e\u043c\u0435\u0440 \u0434\u043d\u044f \u0432 \u0433\u043e\u0434\u0443<\/li><li><strong>MONTH(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043c\u0435\u0441\u044f\u0446 \u0434\u0430\u0442\u044b<\/li><li><strong>YEAR(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0433\u043e\u0434 \u0438\u0437 \u0434\u0430\u0442\u044b<\/li><li><strong>QUARTER(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043d\u043e\u043c\u0435\u0440 \u043a\u0432\u0430\u0440\u0442\u0430\u043b\u0430 \u0433\u043e\u0434\u0430<\/li><li><strong>WEEK(date [, first])<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043d\u043e\u043c\u0435\u0440 \u043d\u0435\u0434\u0435\u043b\u0438 \u0433\u043e\u0434\u0430. \u041d\u0435\u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0437\u0430\u0434\u0430\u0442\u044c \u0441\u0442\u0430\u0440\u0442\u043e\u0432\u044b\u0439 \u0434\u0435\u043d\u044c \u043d\u0435\u0434\u0435\u043b\u0438. \u0415\u0441\u043b\u0438 \u044d\u0442\u043e\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0440\u0430\u0432\u0435\u043d 1, \u0442\u043e \u043f\u0435\u0440\u0432\u044b\u043c \u0434\u043d\u0435\u043c \u0441\u0447\u0438\u0442\u0430\u0435\u0442\u0441\u044f \u043f\u043e\u043d\u0435\u0434\u0435\u043b\u044c\u043d\u0438\u043a, \u0438\u043d\u0430\u0447\u0435 \u0432\u043e\u0441\u043a\u0440\u0435\u0441\u0435\u043d\u044c\u0435<\/li><li><strong>LAST_DAY(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0439 \u0434\u0435\u043d\u044c \u043c\u0435\u0441\u044f\u0446\u0430 \u0432 \u0432\u0438\u0434\u0435 \u0434\u0430\u0442\u044b<\/li><li><strong>DAYNAME(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0434\u043d\u044f \u043d\u0435\u0434\u0435\u043b\u0438<\/li><li><strong>MONTHNAME(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0442\u0435\u043a\u0443\u0449\u0435\u0433\u043e \u043c\u0435\u0441\u044f\u0446\u0430<\/li><li><strong>HOUR(time)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0447\u0430\u0441 \u0432\u0440\u0435\u043c\u0435\u043d\u0438<\/li><li><strong>MINUTE(time)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u0440\u0435\u043c\u0435\u043d\u0438<\/li><li><strong>SECOND(time)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0441\u0435\u043a\u0443\u043d\u0434\u0443 \u0432\u0440\u0435\u043c\u0435\u043d\u0438<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0444\u0443\u043d\u043a\u0446\u0438\u0439:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u0424\u0443\u043d\u043a\u0446\u0438\u044f<\/td><td>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/td><\/tr><tr><td>DAYOFMONTH(&#8216;2018-05-25&#8217;)<\/td><td>25<\/td><\/tr><tr><td>DAYOFWEEK(&#8216;2018-05-25&#8217;)<\/td><td>6<\/td><\/tr><tr><td>DAYOFYEAR(&#8216;2018-05-25&#8217;)<\/td><td>145<\/td><\/tr><tr><td>MONTH(&#8216;2018-05-25&#8217;)<\/td><td>5<\/td><\/tr><tr><td>YEAR(&#8216;2018-05-25&#8217;)<\/td><td>2018<\/td><\/tr><tr><td>QUARTER(&#8216;2018-05-25&#8217;)<\/td><td>2<\/td><\/tr><tr><td>WEEK(&#8216;2018-05-25&#8217;, 1)<\/td><td>21<\/td><\/tr><tr><td>LAST_DAY(&#8216;2018-05-25&#8217;)<\/td><td>2018-05-31<\/td><\/tr><tr><td>DAYNAME(&#8216;2018-05-25&#8217;)<\/td><td>Friday<\/td><\/tr><tr><td>MONTHNAME(&#8216;2018-05-25&#8217;)<\/td><td>May<\/td><\/tr><tr><td>HOUR(&#8217;21:25:54&#8242;)<\/td><td>21<\/td><\/tr><tr><td>MINUTE(&#8217;21:25:54&#8242;)<\/td><td>25<\/td><\/tr><tr><td>SECOND(&#8217;21:25:54&#8242;)<\/td><td>54<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f EXTRACT<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f EXTRACT \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u0435\u0442 \u0438\u0437 \u0434\u0430\u0442\u044b \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043a\u0430\u043a\u043e\u0439-\u0442\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u0439 \u043a\u043e\u043c\u043f\u043e\u043d\u0435\u043d\u0442. \u0415\u0435 \u0444\u043e\u0440\u043c\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td><code>EXTRACT(unit <\/code><code>FROM<\/code> <code>datetime)<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u043d\u0430\u0447\u0435\u043d\u0438\u0435 datetime \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0438\u0441\u0445\u043e\u0434\u043d\u0443\u044e \u0434\u0430\u0442\u0443 \u0438 (\u0438\u043b\u0438) \u0432\u0440\u0435\u043c\u044f, \u0430 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 unit \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u043a\u0430\u043a\u043e\u0439 \u043a\u043e\u043c\u043f\u043e\u043d\u0435\u043d\u0442 \u0434\u0430\u0442\u044b \u0438\u043b\u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0431\u0443\u0434\u0435\u0442 \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u0442\u044c\u0441\u044f. \u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 unit \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0442\u044c \u043e\u0434\u043d\u043e \u0438\u0437 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0445 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>SECOND<\/code>&nbsp;(\u0441\u0435\u043a\u0443\u043d\u0434\u044b)<\/li><li><code>MINUTE<\/code>&nbsp;(\u043c\u0438\u043d\u0443\u0442\u044b)<\/li><li><code>HOUR<\/code>&nbsp;(\u0447\u0430\u0441)<\/li><li><code>DAY<\/code>&nbsp;(\u0434\u0435\u043d\u044c)<\/li><li><code>MONTH<\/code>&nbsp;(\u043c\u0435\u0441\u044f\u0446)<\/li><li><code>YEAR<\/code>&nbsp;(\u0433\u043e\u0434)<\/li><li><code>MINUTE_SECOND<\/code>&nbsp;(\u043c\u0438\u043d\u0443\u0442\u044b \u0438 \u0441\u0435\u043a\u0443\u043d\u0434\u044b)<\/li><li><code>HOUR_MINUTE<\/code>&nbsp;(\u0447\u0430\u0441\u044b \u0438 \u043c\u0438\u043d\u0443\u0442\u044b)<\/li><li><code>DAY_HOUR<\/code>&nbsp;(\u0434\u0435\u043d\u044c \u0438 \u0447\u0430\u0441\u044b)<\/li><li><code>YEAR_MONTH<\/code>&nbsp;(\u0433\u043e\u0434 \u0438 \u043c\u0435\u0441\u044f\u0446)<\/li><li><code>HOUR_SECOND<\/code>&nbsp;(\u0447\u0430\u0441\u044b, \u043c\u0438\u043d\u0443\u0442\u044b \u0438 \u0441\u0435\u043a\u0443\u043d\u0434\u044b)<\/li><li><code>DAY_MINUTE<\/code>&nbsp;(\u0434\u0435\u043d\u044c, \u0447\u0430\u0441\u044b \u0438 \u043c\u0438\u043d\u0443\u0442\u044b)<\/li><li><code>DAY_SECOND<\/code>&nbsp;(\u0434\u0435\u043d\u044c, \u0447\u0430\u044b, \u043c\u0438\u043d\u0443\u0442\u044b \u0438 \u0441\u0435\u043a\u0443\u043d\u0434\u044b)<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0432\u044b\u0437\u043e\u0432\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u0438:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u0412\u044b\u0437\u043e\u0432<\/td><td>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/td><\/tr><tr><td>EXTRACT( SECOND FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>54<\/td><\/tr><tr><td>EXTRACT( MINUTE FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>25<\/td><\/tr><tr><td>EXTRACT( HOUR FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>21<\/td><\/tr><tr><td>EXTRACT( DAY FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>25<\/td><\/tr><tr><td>EXTRACT( MONTH FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>5<\/td><\/tr><tr><td>EXTRACT( YEAR FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>2018<\/td><\/tr><tr><td>EXTRACT( MINUTE_SECOND FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>2554<\/td><\/tr><tr><td>EXTRACT( DAY_HOUR FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>2521<\/td><\/tr><tr><td>EXTRACT( YEAR_MONTH FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>201805<\/td><\/tr><tr><td>EXTRACT( HOUR_SECOND FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>212554<\/td><\/tr><tr><td>EXTRACT( DAY_MINUTE FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>252125<\/td><\/tr><tr><td>EXTRACT( DAY_SECOND FROM &#8216;2018-05-25 21:25:54&#8217;)<\/td><td>25212554<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u044f\u0446\u0438\u0438 \u0441 \u0434\u0430\u0442\u0430\u043c\u0438<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u0420\u044f\u0434 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0442 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u0441\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0438 \u0432\u044b\u0447\u0438\u0442\u0430\u043d\u0438\u044f \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>DATE_ADD(date, INTERVAL expression unit)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u044a\u0435\u043a\u0442 DATE \u0438\u043b\u0438 DATETIME, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c \u0441\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0434\u0430\u0442\u044b date \u0441 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u043c \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b\u043e\u043c. \u0418\u043d\u0442\u0435\u0440\u0432\u0430\u043b \u0437\u0430\u0434\u0430\u0435\u0442\u0441\u044f \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f&nbsp;<code>INTERVAL expression unit<\/code>, \u0433\u0434\u0435&nbsp;<code>INTERVAL<\/code>&nbsp;\u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0435 \u0441\u043b\u043e\u0432\u043e,&nbsp;<code>expression<\/code>&nbsp;&#8211; \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c\u044b\u0445 \u043a \u0434\u0430\u0442\u0435 \u0435\u0434\u0438\u043d\u0438\u0446, \u0430&nbsp;<code>unit<\/code>&nbsp;&#8211; \u0442\u0438\u043f \u0435\u0434\u0438\u043d\u0438\u0446 (\u0447\u0430\u0441\u044b, \u0434\u043d\u0438 \u0438 \u0442.\u0434.) \u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440&nbsp;<code>unit<\/code>&nbsp;\u043c\u043e\u0436\u0435\u0442 \u0438\u043c\u0435\u0442\u044c \u0442\u0435 \u0436\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0447\u0442\u043e \u0438 \u0432 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 EXTRACT, \u0442\u043e \u0435\u0441\u0442\u044c DAY, HOUR \u0438 \u0442.\u0434.<\/li><li><strong>DATE_SUB(date, INTERVAL expression unit)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u044a\u0435\u043a\u0442 DATE \u0438\u043b\u0438 DATETIME, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c \u0432\u044b\u0447\u0438\u0442\u0430\u043d\u0438\u044f \u0438\u0437 \u0434\u0430\u0442\u044b date \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u043e\u0433\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b\u0430<\/li><li><strong>DATEDIFF(date1, date2)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0440\u0430\u0437\u043d\u0438\u0446\u0443 \u0432 \u0434\u043d\u044f\u0445 \u043c\u0435\u0436\u0434\u0443 \u0434\u0430\u0442\u0430\u043c\u0438 date1 \u0438 date2<\/li><li><strong>TO_DAYS(date)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0434\u043d\u0435\u0439 \u0441 0-\u0433\u043e \u0433\u043e\u0434\u0430<\/li><li><strong>TIME_TO_SEC(time)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0441\u0435\u043a\u0443\u043d\u0434, \u043f\u0440\u043e\u0448\u0435\u0434\u0448\u0438\u0445 \u0441 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043f\u043e\u043b\u0443\u043d\u043e\u0447\u0438<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0438\u043c\u0435\u0440\u044b \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u044f:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u0412\u044b\u0437\u043e\u0432<\/td><td>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/td><\/tr><tr><td>DATE_ADD(&#8216;2018-05-25&#8217;, INTERVAL 1 DAY)<\/td><td>2018-05-26<\/td><\/tr><tr><td>DATE_ADD(&#8216;2018-05-25&#8217;, INTERVAL 3 MONTH)<\/td><td>2018-08-25<\/td><\/tr><tr><td>DATE_ADD(&#8216;2018-05-25 21:31:27&#8217;, INTERVAL 4 HOUR)<\/td><td>2018-05-26 01:31:27<\/td><\/tr><tr><td>DATE_SUB(&#8216;2018-05-25&#8217;, INTERVAL 4 DAY)<\/td><td>2018-05-21<\/td><\/tr><tr><td>DATEDIFF(&#8216;2018-05-25&#8217;, &#8216;2018-05-27&#8217;)<\/td><td>-2<\/td><\/tr><tr><td>DATEDIFF(&#8216;2018-05-25&#8217;, &#8216;2018-05-21&#8217;)<\/td><td>4<\/td><\/tr><tr><td>DATEDIFF(&#8216;2018-05-25&#8217;, &#8216;2018-03-21&#8217;)<\/td><td>65<\/td><\/tr><tr><td>TO_DAYS(&#8216;2018-05-25&#8217;)<\/td><td>737204<\/td><\/tr><tr><td>TIME_TO_SEC(&#8217;10:00&#8242;)<\/td><td>36000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u0424\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u0442 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>DATE_FORMAT(date, format)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u044a\u0435\u043a\u0442 DATE \u0438\u043b\u0438 DATETIME, \u043e\u0442\u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0448\u0430\u0431\u043b\u043e\u043d\u0430 format<\/li><li><strong>TIME_FORMAT(date, format)<\/strong>&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u044a\u0435\u043a\u0442 TIME \u0438\u043b\u0438 DATETIME, \u043e\u0442\u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0448\u0430\u0431\u043b\u043e\u043d\u0430 format<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u0431\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0432\u0442\u043e\u0440\u043e\u0433\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u044e\u0442 \u0441\u0442\u0440\u043e\u043a\u0443 \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u043b\u0438 \u0448\u0430\u0431\u043b\u043e\u043d, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u043a\u0430\u043a \u043e\u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435. \u042d\u0442\u043e\u0442 \u0448\u0430\u0431\u043b\u043e\u043d \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>%m<\/code>: \u043c\u0435\u0441\u044f\u0446 \u0432 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 01..12<\/li><li><code>%\u0441<\/code>: \u043c\u0435\u0441\u044f\u0446 \u0432 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 1..12<\/li><li><code>%M<\/code>: \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043c\u0435\u0441\u044f\u0446\u0430 (January&#8230;December)<\/li><li><code>%b<\/code>: \u0430\u0431\u0431\u0440\u0435\u0432\u0438\u0430\u0442\u0443\u0440\u0430 \u043c\u0435\u0441\u044f\u0446\u0430 (Jan&#8230;Dec)<\/li><li><code>%d<\/code>: \u0434\u0435\u043d\u044c \u043c\u0435\u0441\u044f\u0446\u0430 \u0432 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 00..31<\/li><li><code>%e<\/code>: \u0434\u0435\u043d\u044c \u043c\u0435\u0441\u044f\u0446\u0430 \u0432 \u0447\u0438\u0441\u043b\u043e\u0432\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 0..31<\/li><li><code>%D<\/code>: \u043d\u043e\u043c\u0435\u0440 \u0434\u043d\u044f \u043c\u0435\u0441\u044f\u0446\u0430 \u0441 \u0441\u0443\u0444\u0444\u0438\u043a\u0441\u043e\u043c (1st, 2nd, 3rd&#8230;)<\/li><li><code>%y<\/code>: \u0433\u043e\u0434 \u0432 \u0432\u0438\u0434\u0435 \u0434\u0432\u0443\u0445 \u0447\u0438\u0441\u0435\u043b<\/li><li><code>%Y<\/code>: \u0433\u043e\u0434 \u0432 \u0432\u0438\u0434\u0435 \u0447\u0435\u0442\u044b\u0440\u0435\u0445 \u0447\u0438\u0441\u0435\u043b<\/li><li><code>%W<\/code>: \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0434\u043d\u044f \u043d\u0435\u0434\u0435\u043b\u0438 (Sunday&#8230;Saturday)<\/li><li><code>%a<\/code>: \u0430\u0431\u0431\u0440\u0435\u0432\u0438\u0430\u0442\u0443\u0440\u0430 \u0434\u043d\u044f \u043d\u0435\u0434\u0435\u043b\u0438 (Sun&#8230;Sat)<\/li><li><code>%H<\/code>: \u0447\u0430\u0441 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 00..23<\/li><li><code>%k<\/code>: \u0447\u0430\u0441 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 0..23<\/li><li><code>%h<\/code>: \u0447\u0430\u0441 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 01..12<\/li><li><code>%l<\/code>: \u0447\u0430\u0441 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 1..12<\/li><li><code>%i<\/code>: \u043c\u0438\u043d\u0443\u0442\u044b \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 00..59<\/li><li><code>%r<\/code>: \u0432\u0440\u0435\u043c\u044f \u0432 12-\u0442\u0438 \u0447\u0430\u0441\u043e\u0432\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 (hh:mm:ss AM \u0438\u043b\u0438 PM)<\/li><li><code>%T<\/code>: \u0432\u0440\u0435\u043c\u044f \u0432 24-\u0442\u0438 \u0447\u0430\u0441\u043e\u0432\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 (hh:mm:ss)<\/li><li><code>%S<\/code>: \u0441\u0435\u043a\u0443\u043d\u0434\u044b \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 00..59<\/li><li><code>%p<\/code>: AM \u0438\u043b\u0438 PM<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0438\u043c\u0435\u0440\u044b \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u044f:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u0412\u044b\u0437\u043e\u0432<\/td><td>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/td><\/tr><tr><td>DATE_FORMAT(&#8216;2018-05-25&#8217;, &#8216;%d\/%m\/%y&#8217;)<\/td><td>25\/05\/18<\/td><\/tr><tr><td>DATE_FORMAT(&#8216;2018-05-25 21:25:54&#8217;, &#8216;%d %M %Y&#8217;)<\/td><td>25 May 2018<\/td><\/tr><tr><td>DATE_FORMAT(&#8216;2018-05-25 21:25:54&#8217;, &#8216;%r&#8217;)<\/td><td>09:25:54 PM<\/td><\/tr><tr><td>TIME_FORMAT(&#8216;2018-05-25 21:25:54&#8217;, &#8216;%H:%i:%S&#8217;)<\/td><td>21:25:24<\/td><\/tr><tr><td>TIME_FORMAT(&#8217;21:25:54&#8242;, &#8216;%k:%i&#8217;)<\/td><td>21:25<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0412 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u043d\u0430\u0439\u0434\u0435\u043c \u0437\u0430\u043a\u0430\u0437\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0431\u044b\u043b\u0438 \u0441\u0434\u0435\u043b\u0430\u043d\u044b 5 \u0434\u043d\u0435\u0439 \u043d\u0430\u0437\u0430\u0434:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<br>2<\/td><td><code>SELECT<\/code> <code>* FROM<\/code> <code>Orders<\/code><br><code>WHERE<\/code> <code>DATEDIFF(CURDATE(), CreatedAt) = 5;<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/metanit.com\/sql\/mysql\/pics\/8.2.png\" alt=\"\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c \u0432 MySQL\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u0438\u043c\u0435\u0435\u0442 \u0440\u044f\u0434 \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u0442\u0430\u043c\u0438 \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c. \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u0442\u044b \u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0424\u0443\u043d\u043a\u0446\u0438\u0438&nbsp;NOW(),&nbsp;SYSDATE(),&nbsp;CURRENT_TIMESTAMP()&nbsp;\u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u0443\u044e \u0434\u0430\u0442\u0443 \u0438 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[75],"tags":[],"class_list":["post-798","page","type-page","status-publish","hentry","category-rukovodstvo-po-mysql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/comments?post=798"}],"version-history":[{"count":0,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/798\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/media?parent=798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/categories?post=798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/tags?post=798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}