{"id":13402,"date":"2024-08-23T14:29:00","date_gmt":"2024-08-23T07:29:00","guid":{"rendered":"https:\/\/km.ict.buu.ac.th\/?p=13402"},"modified":"2024-08-26T14:38:48","modified_gmt":"2024-08-26T07:38:48","slug":"%e0%b8%81%e0%b8%b2%e0%b8%a3%e0%b8%aa%e0%b8%a3%e0%b9%89%e0%b8%b2%e0%b8%87%e0%b8%a7%e0%b8%b1%e0%b8%99%e0%b8%97%e0%b8%b5%e0%b9%88%e0%b8%88%e0%b8%b2%e0%b8%81%e0%b8%8a%e0%b9%88%e0%b8%a7%e0%b8%87%e0%b8%a7","status":"publish","type":"post","link":"https:\/\/km.ict.buu.ac.th\/?p=13402","title":{"rendered":"\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e08\u0e32\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e14\u0e49\u0e27\u0e22\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 SQL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"13402\" class=\"elementor elementor-13402\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0f44127 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f44127\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2ba66bd\" data-id=\"2ba66bd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b0f9f8a elementor-widget elementor-widget-text-editor\" data-id=\"b0f9f8a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p class=\"MsoNormal\" style=\"text-indent: 18.0pt;border: none\"><span lang=\"TH\">\u00a0 \u00a0 \u00a0\u0e43\u0e19\u0e01\u0e32\u0e23\u0e17\u0e33\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e2d\u0e2d\u0e01\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19 \u0e1a\u0e32\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19\u0e43\u0e19\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 \u0e41\u0e15\u0e48\u0e16\u0e49\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e21\u0e35\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19 \u0e01\u0e32\u0e23\u0e14\u0e36\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e30\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e21\u0e35\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2b\u0e32\u0e22\u0e44\u0e1b \u0e0b\u0e36\u0e48\u0e07\u0e08\u0e30\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e44\u0e21\u0e48\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07 \u0e43\u0e19\u0e01\u0e32\u0e23\u0e19\u0e35\u0e49\u0e08\u0e36\u0e07\u0e44\u0e14\u0e49\u0e17\u0e33\u0e04\u0e34\u0e27\u0e23\u0e35\u0e48\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e08\u0e32\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23 \u0e14\u0e31\u0e07\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e25\u0e48\u0e32\u0e07<\/span><\/p><div>&#8212; mysql<\/div><div>select f.split_date from\u00a0<\/div><div>(select adddate(&#8216;2024-08-01&#8217;,e.i*10000 + d.i*1000 + c.i*100 + b.i*10 + a.i) split_date from<\/div><div>(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) a,<\/div><div>(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) b,<\/div><div>(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) c,<\/div><div>(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) d,<\/div><div>(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) e) f<\/div><div>where f.split_date between &#8216;2024-08-01&#8217; and &#8216;2024-08-08&#8217;;<\/div><div>\u00a0<\/div><div>&#8212; sql server<\/div><div>declare @start_date date = &#8216;2024-08-01&#8217;<\/div><div>declare @end_date date = &#8216;2024-08-08&#8217;<\/div><div>select top\u00a0<\/div><div>\u00a0 \u00a0 (datediff(day, @start_date, @end_date) + 1)<\/div><div>\u00a0 \u00a0 split_date = dateadd(day, row_number() over(order by a.object_id) &#8211; 1, @start_date)<\/div><div>from sys.all_objects a<\/div><div>cross join sys.all_objects b;<\/div><div>\u00a0<\/div><div>&#8212; oracle<\/div><div>select to_char(date &#8216;2024-08-01&#8217; + level &#8211; 1, &#8216;yyyy-mm-dd&#8217;) as split_date\u00a0<\/div><div>from dual<\/div><div>connect by level &lt;= date &#8216;2024-08-08&#8217; &#8211; date &#8216;2024-08-01&#8217; + 1;<\/div><p><img decoding=\"async\" class=\"size-full wp-image-13404 aligncenter\" src=\"https:\/\/km.ict.buu.ac.th\/wp-content\/uploads\/2024\/08\/Image-7.png\" alt=\"\" width=\"142\" height=\"269\" \/><\/p><p>\u0e08\u0e32\u0e01\u0e20\u0e32\u0e1e \u0e40\u0e1b\u0e47\u0e19\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e1c\u0e25\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e08\u0e32\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48 2024-08-01 \u0e16\u0e36\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48 2024-08-08<\/p><p>\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; &nbsp;\u0e43\u0e19\u0e01\u0e32\u0e23\u0e17\u0e33\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e2d\u0e2d\u0e01\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19 \u0e1a\u0e32\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19\u0e43\u0e19\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 \u0e41\u0e15\u0e48\u0e16\u0e49\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e21\u0e35\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19 \u0e01\u0e32\u0e23\u0e14\u0e36\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e30\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e21\u0e35\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2b\u0e32\u0e22\u0e44\u0e1b \u0e0b\u0e36\u0e48\u0e07\u0e08\u0e30\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e44\u0e21\u0e48\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07 \u0e43\u0e19\u0e01\u0e32\u0e23\u0e19\u0e35\u0e49\u0e08\u0e36\u0e07\u0e44\u0e14\u0e49\u0e17\u0e33\u0e04\u0e34\u0e27\u0e23\u0e35\u0e48\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e08\u0e32\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23 \u0e14\u0e31\u0e07\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e25\u0e48\u0e32\u0e07 &#8212; mysqlselect f.split_date from&nbsp;(select adddate(&#8216;2024-08-01&#8217;,e.i*10000 + d.i*1000 + c.i*100 + b.i*10 + a.i) split_date from(select 0 i union select 1 union select 2 union select 3 union select 4 union select &hellip; <\/p>\n","protected":false},"author":56,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"pmpro_default_level":"","footnotes":""},"categories":[729,692,695],"tags":[],"class_list":["post-13402","post","type-post","status-publish","format-standard","hentry","category-explicit-knowledge","category-services-knowledge","category-developer","pmpro-has-access"],"jetpack_featured_media_url":"","rttpg_featured_image_url":null,"rttpg_author":{"display_name":"jessada","author_link":"https:\/\/km.ict.buu.ac.th\/?author=56"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/km.ict.buu.ac.th\/?cat=729\" rel=\"category\">Explicit Knowledge<\/a> <a href=\"https:\/\/km.ict.buu.ac.th\/?cat=692\" rel=\"category\">\u0e0a\u0e38\u0e21\u0e0a\u0e19\u0e01\u0e32\u0e23\u0e1a\u0e23\u0e34\u0e01\u0e32\u0e23\u0e41\u0e25\u0e30\u0e04\u0e27\u0e32\u0e21\u0e23\u0e39\u0e49<\/a> <a href=\"https:\/\/km.ict.buu.ac.th\/?cat=695\" rel=\"category\">\u0e0a\u0e38\u0e21\u0e0a\u0e19\u0e19\u0e31\u0e01\u0e1e\u0e31\u0e12\u0e19\u0e32<\/a>","rttpg_excerpt":"&nbsp; &nbsp; &nbsp;\u0e43\u0e19\u0e01\u0e32\u0e23\u0e17\u0e33\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e2d\u0e2d\u0e01\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19 \u0e1a\u0e32\u0e07\u0e04\u0e23\u0e31\u0e49\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19\u0e43\u0e19\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 \u0e41\u0e15\u0e48\u0e16\u0e49\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e21\u0e35\u0e17\u0e38\u0e01\u0e27\u0e31\u0e19 \u0e01\u0e32\u0e23\u0e14\u0e36\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e30\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e21\u0e35\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2b\u0e32\u0e22\u0e44\u0e1b \u0e0b\u0e36\u0e48\u0e07\u0e08\u0e30\u0e17\u0e33\u0e43\u0e2b\u0e49\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e44\u0e21\u0e48\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07 \u0e43\u0e19\u0e01\u0e32\u0e23\u0e19\u0e35\u0e49\u0e08\u0e36\u0e07\u0e44\u0e14\u0e49\u0e17\u0e33\u0e04\u0e34\u0e27\u0e23\u0e35\u0e48\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e08\u0e32\u0e01\u0e0a\u0e48\u0e27\u0e07\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23 \u0e14\u0e31\u0e07\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e25\u0e48\u0e32\u0e07 &#8212; mysqlselect f.split_date from&nbsp;(select adddate(&#8216;2024-08-01&#8217;,e.i*10000 + d.i*1000 + c.i*100 + b.i*10 + a.i) split_date from(select 0 i union select 1 union select 2 union select 3 union select 4 union select &hellip;","_links":{"self":[{"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=\/wp\/v2\/posts\/13402"}],"collection":[{"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=\/wp\/v2\/users\/56"}],"replies":[{"embeddable":true,"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13402"}],"version-history":[{"count":8,"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=\/wp\/v2\/posts\/13402\/revisions"}],"predecessor-version":[{"id":13412,"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=\/wp\/v2\/posts\/13402\/revisions\/13412"}],"wp:attachment":[{"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/km.ict.buu.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}