{"id":3412,"date":"2016-07-26T03:39:46","date_gmt":"2016-07-26T03:39:46","guid":{"rendered":"https:\/\/kiencang.net\/?p=3412"},"modified":"2016-07-26T03:39:46","modified_gmt":"2016-07-26T03:39:46","slug":"cac-ham-ngay-thang-trong-sql","status":"publish","type":"post","link":"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/","title":{"rendered":"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_60 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6577d654e71c6\" ><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6577d654e71c6\"  type=\"checkbox\" id=\"item-6577d654e71c6\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#SQL_Dates\" title=\"SQL Dates\">SQL Dates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#Cac_ham_ngay_thang_trong_MySQL\" title=\"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong MySQL\">C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#Cac_ham_ngay_thang_cua_SQL_Server\" title=\"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng c\u1ee7a SQL Server\">C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng c\u1ee7a SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#Cac_kieu_du_lieu_ngay_thang_trong_SQL\" title=\"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong SQL\">C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#SQL_lam_viec_voi_ngay_thang\" title=\"SQL l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng\">SQL l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SQL_Dates\"><\/span>SQL Dates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ph\u1ea7n kh\u00f3 kh\u0103n nh\u1ea5t khi l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng l\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n ch\u00e8n v\u00e0o ph\u1ea3i \u0103n kh\u1edbp v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a c\u1ed9t trong c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n\n\n\n<p>Mi\u1ec5n l\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ec9 ch\u1ee9a c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng, truy v\u1ea5n c\u1ee7a b\u1ea1n s\u1ebd l\u00e0m vi\u1ec7c nh\u01b0 mong \u0111\u1ee3i. Tuy nhi\u00ean, n\u1ebfu m\u1ed9t ph\u1ea7n th\u1eddi gian (gi\u1edd ph\u00fat gi\u00e2y) c\u00f3 li\u00ean quan, n\u00f3 s\u1ebd tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p.<\/p>\n\n\n\n<p>Tr\u01b0\u1edbc khi n\u00f3i v\u1ec1 s\u1ef1 ph\u1ee9c t\u1ea1p c\u1ee7a truy v\u1ea5n ng\u00e0y th\u00e1ng, ch\u00fang ta s\u1ebd xem th\u1eed c\u00e1c h\u00e0m quan tr\u1ecdng nh\u1ea5t \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_ham_ngay_thang_trong_MySQL\"><\/span>C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m quan tr\u1ecdng nh\u1ea5t \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong MySQL:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>Function<\/th><th>M\u00f4 t\u1ea3<\/th><\/tr><tr><td>NOW()<\/td><td>Tr\u1ea3 v\u1ec1 ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i<\/td><\/tr><tr><td>CURDATE()<\/td><td>Tr\u1ea3 v\u1ec1 ng\u00e0y hi\u1ec7n t\u1ea1i<\/td><\/tr><tr><td>CURTIME()<\/td><td>Tr\u1ea3 v\u1ec1 th\u1eddi gian hi\u1ec7n t\u1ea1i<\/td><\/tr><tr><td>DATE()<\/td><td>Tr\u00edch xu\u1ea5t c\u00e1c ph\u1ea7n ng\u00e0y c\u1ee7a m\u1ed9t ng\u00e0y ho\u1eb7c bi\u1ec3u th\u1ee9c ng\u00e0y \/ th\u1eddi gian<\/td><\/tr><tr><td>EXTRACT()<\/td><td>Tr\u1ea3 v\u1ec1 m\u1ed9t ph\u1ea7n c\u1ee7a ng\u00e0y th\u00e1ng<\/td><\/tr><tr><td>DATE_ADD()<\/td><td>Th\u00eam m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh v\u00e0o m\u1ed9t ng\u00e0y<\/td><\/tr><tr><td>DATE_SUB()<\/td><td>B\u1edbt m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh t\u1eeb m\u1ed9t ng\u00e0y<\/td><\/tr><tr><td>DATEDIFF()<\/td><td>Tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y gi\u1eefa hai kho\u1ea3ng ng\u00e0y th\u00e1ng n\u00e0o \u0111\u00f3<\/td><\/tr><tr><td>DATE_FORMAT()<\/td><td>Hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng\/th\u1eddi gian trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_ham_ngay_thang_cua_SQL_Server\"><\/span>C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng c\u1ee7a SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y li\u1ec7t k\u00ea c\u00e1c h\u00e0m quan tr\u1ecdng nh\u1ea5t \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong SQL Server:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>Function<\/th><th>M\u00f4 t\u1ea3<\/th><\/tr><tr><td>GETDATE()<\/td><td>Tr\u1ea3 v\u1ec1 ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i<\/td><\/tr><tr><td>DATEPART()<\/td><td>Tr\u1ea3 v\u1ec1 m\u1ed9t ph\u1ea7n c\u1ee7a ng\u00e0y th\u00e1ng\/th\u1eddi gian<\/td><\/tr><tr><td>DATEADD()<\/td><td>Th\u00eam ho\u1eb7c b\u1edbt m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh t\u1eeb m\u1ed9t ng\u00e0y<\/td><\/tr><tr><td>DATEDIFF()<\/td><td>Tr\u1ea3 v\u1ec1 th\u1eddi gian gi\u1eefa hai ng\u00e0y th\u00e1ng<\/td><\/tr><tr><td>CONVERT()<\/td><td>Hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng\/th\u1eddi gian trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_kieu_du_lieu_ngay_thang_trong_SQL\"><\/span>C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>MySQL&nbsp;<\/strong>\u0111i k\u00e8m v\u1edbi c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u sau \u0111\u00e2y \u0111\u1ec3 l\u01b0u tr\u1eef gi\u00e1 tr\u1ecb ng\u00e0y ho\u1eb7c ng\u00e0y th\u00e1ng \/ th\u1eddi gian trong c\u01a1 s\u1edf d\u1eef li\u1ec7u (Y l\u00e0 n\u0103m, M l\u00e0 th\u00e1ng, D l\u00e0 ng\u00e0y, H l\u00e0 gi\u1edd, MI l\u00e0 ph\u00fat, SS l\u00e0 gi\u00e2y; YYYY l\u00e0 n\u0103m \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng b\u1ed1n ch\u1eef s\u1ed1, YY l\u00e0 n\u0103m \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng hai ch\u1eef s\u1ed1; MM l\u00e0 l\u01b0u th\u00e1ng d\u01b0\u1edbi d\u1ea1ng hai ch\u1eef s\u1ed1, v\u00ed d\u1ee5 th\u00e1ng 7 s\u1ebd l\u00e0 07):<\/p>\n\n\n\n<ul><li>DATE \u2013 \u0111\u1ecbnh d\u1ea1ng YYYY-MM-DD<\/li><li>DATETIME \u2013 \u0111\u1ecbnh d\u1ea1ng: YYYY-MM-DD HH:MI:SS<\/li><li>TIMESTAMP \u2013 \u0111\u1ecbnh d\u1ea1ng: YYYY-MM-DD HH:MI:SS<\/li><li>YEAR \u2013 \u0111\u1ecbnh d\u1ea1ng YYYY or YY<\/li><\/ul>\n\n\n\n<p><strong>SQL Server&nbsp;<\/strong>\u0111i k\u00e8m v\u1edbi c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u sau \u0111\u1ec3 l\u01b0u tr\u1eef gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng ho\u1eb7c ng\u00e0y th\u00e1ng\/th\u1eddi gian trong c\u01a1 s\u1edf d\u1eef li\u1ec7u:<\/p>\n\n\n\n<ul><li>DATE \u2013 \u0111\u1ecbnh d\u1ea1ng YYYY-MM-DD<\/li><li>DATETIME \u2013 \u0111\u1ecbnh d\u1ea1ng: YYYY-MM-DD HH:MI:SS<\/li><li>SMALLDATETIME \u2013 \u0111\u1ecbnh d\u1ea1ng: YYYY-MM-DD HH:MI:SS<\/li><li>TIMESTAMP \u2013 \u0111\u1ecbnh d\u1ea1ng: m\u1ed9t s\u1ed1 duy nh\u1ea5t<\/li><\/ul>\n\n\n\n<p><strong>L\u01b0u \u00fd<\/strong>: C\u00e1c ki\u1ec3u ng\u00e0y th\u00e1ng l\u1ef1a ch\u1ecdn cho c\u1ed9t khi b\u1ea1n t\u1ea1o b\u1ea3ng m\u1edbi trong c\u01a1 s\u1edf d\u1eef li\u1ec7u!<\/p>\n\n\n\n<p>\u0110\u1ec3 c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u c\u00f3 th\u1ec3 c\u00f3, h\u00e3y truy c\u1eadp v\u00e0o th\u01b0 m\u1ee5c c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u00f4i.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SQL_lam_viec_voi_ngay_thang\"><\/span>SQL l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh hai ng\u00e0y th\u00e1ng m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng n\u1ebfu kh\u00f4ng c\u00f3 th\u00e0nh ph\u1ea7n th\u1eddi gian tham gia!<\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng \u201cOrders\u201d gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>OrderId<\/th><th>ProductName<\/th><th>OrderDate<\/th><\/tr><tr><td>1<\/td><td>Geitost<\/td><td>2008-11-11<\/td><\/tr><tr><td>2<\/td><td>Camembert Pierrot<\/td><td>2008-11-09<\/td><\/tr><tr><td>3<\/td><td>Mozzarella di Giovanni<\/td><td>2008-11-11<\/td><\/tr><tr><td>4<\/td><td>Mascarpone Fabioli<\/td><td>2008-10-29<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>B\u00e2y gi\u1edd ch\u00fang ta mu\u1ed1n ch\u1ecdn b\u1ea3n ghi b\u1edbi OrderDate l\u00e0 \u201c2008-11-11\u201d t\u1eeb b\u1ea3ng tr\u00ean.<\/p>\n\n\n\n<p>Ch\u00fang ta s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SELECT sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Orders WHERE OrderDate='2008-11-11'<\/code><\/pre>\n\n\n\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>OrderId<\/th><th>ProductName<\/th><th>OrderDate<\/th><\/tr><tr><td>1<\/td><td>Geitost<\/td><td>2008-11-11<\/td><\/tr><tr><td>3<\/td><td>Mozzarella di Giovanni<\/td><td>2008-11-11<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>B\u00e2y gi\u1edd gi\u1ea3 s\u1eed b\u1ea3ng \u201cOrders\u201d tr\u00f4ng gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y (l\u01b0u \u00fd l\u00e0 ph\u1ea7n gian c\u00f3 trong c\u1ed9t \u201cOrderDate\u201d):<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>OrderId<\/th><th>ProductName<\/th><th>OrderDate<\/th><\/tr><tr><td>1<\/td><td>Geitost<\/td><td>2008-11-11 13:23:44<\/td><\/tr><tr><td>2<\/td><td>Camembert Pierrot<\/td><td>2008-11-09 15:45:21<\/td><\/tr><tr><td>3<\/td><td>Mozzarella di Giovanni<\/td><td>2008-11-11 11:12:01<\/td><\/tr><tr><td>4<\/td><td>Mascarpone Fabioli<\/td><td>2008-10-29 14:56:59<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>N\u1ebfu ch\u00fang ta s\u1eed d\u1ee5ng c\u00f9ng c\u00e2u l\u1ec7nh SELECT nh\u01b0 tr\u00ean:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Orders WHERE OrderDate='2008-11-11'<\/code><\/pre>\n\n\n\n<p>Ch\u00fang ta s\u1ebd kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 n\u00e0o. \u0110i\u1ec1u n\u00e0y l\u00e0 b\u1edfi c\u00e2u truy v\u1ea5n tr\u00ean ch\u1ec9 d\u00e0nh cho ng\u00e0y th\u00e1ng kh\u00f4ng c\u00f3 ph\u1ea7n th\u1eddi gian \u0111i k\u00e8m.<\/p>\n\n\n\n<p><strong>M\u1eb9o:&nbsp;<\/strong>N\u1ebfu b\u1ea1n gi\u1eef c\u00e2u truy v\u1ea5n c\u1ee7a b\u1ea1n \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 bao tr\u00ec, \u0111\u1eebng \u0111\u01b0a ph\u1ea7n th\u1eddi gian gi\u1edd ph\u00fat gi\u00e2y v\u00e0o trong ng\u00e0y th\u00e1ng c\u1ee7a b\u1ea1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Dates Ph\u1ea7n kh\u00f3 kh\u0103n nh\u1ea5t khi l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng l\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n ch\u00e8n v\u00e0o ph\u1ea3i \u0103n kh\u1edbp v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a c\u1ed9t trong c\u01a1 s\u1edf d\u1eef li\u1ec7u. Mi\u1ec5n l\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ec9 ch\u1ee9a c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng, truy v\u1ea5n &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[239],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL &#8226; Ki\u1ebfn c\u00e0ng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"SQL Dates Ph\u1ea7n kh\u00f3 kh\u0103n nh\u1ea5t khi l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng l\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n ch\u00e8n v\u00e0o ph\u1ea3i \u0103n kh\u1edbp v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a c\u1ed9t trong c\u01a1 s\u1edf d\u1eef li\u1ec7u. Mi\u1ec5n l\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ec9 ch\u1ee9a c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng, truy v\u1ea5n &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-26T03:39:46+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL &#8226; Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL &#8226; Ki\u1ebfn c\u00e0ng","og_description":"SQL Dates Ph\u1ea7n kh\u00f3 kh\u0103n nh\u1ea5t khi l\u00e0m vi\u1ec7c v\u1edbi ng\u00e0y th\u00e1ng l\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n ch\u00e8n v\u00e0o ph\u1ea3i \u0103n kh\u1edbp v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng c\u1ee7a c\u1ed9t trong c\u01a1 s\u1edf d\u1eef li\u1ec7u. Mi\u1ec5n l\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ec9 ch\u1ee9a c\u00e1c th\u00f4ng tin ng\u00e0y th\u00e1ng, truy v\u1ea5n &hellip;","og_url":"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-26T03:39:46+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"4 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/","url":"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/","name":"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-26T03:39:46+00:00","dateModified":"2016-07-26T03:39:46+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/cac-ham-ngay-thang-trong-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e1c h\u00e0m ng\u00e0y th\u00e1ng trong SQL"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3412"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=3412"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3412\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}