{"id":2399,"date":"2023-07-22T10:54:11","date_gmt":"2023-07-22T10:54:11","guid":{"rendered":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/"},"modified":"2023-07-22T10:54:11","modified_gmt":"2023-07-22T10:54:11","slug":"rentang-tanggal-kueri-mongodb","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/","title":{"rendered":"Mongodb: cara melakukan kueri dengan rentang tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk melakukan kueri dengan rentang tanggal di MongoDB:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.collection.find({\n    day: {\n        <span style=\"color: #3366ff;\">$gt<\/span> : ISODate(\" <span style=\"color: #008000;\">2020-01-21<\/span> \"),\n        <span style=\"color: #3366ff;\">$lt<\/span> : ISODate(\" <span style=\"color: #008000;\">2020-01-24<\/span> \")\n    }\n})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini akan mengembalikan semua dokumen dalam koleksi yang bidang &#8220;harinya&#8221; lebih besar dari 21-01-2020 dan kurang dari 24-01-2020.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <span style=\"padding: 1px; border: 1px solid black;\">$gt<\/span> menunjukkan &#8220;lebih besar dari&#8221; dan <span style=\"padding: 1px; border: 1px solid black;\">$lt<\/span> menunjukkan &#8220;kurang dari&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat menggunakan <span style=\"padding: 1px; border: 1px solid black;\">$gte<\/span> untuk &#8220;lebih besar dari atau sama dengan&#8221; dan <span style=\"padding: 1px; border: 1px solid black;\">$lte<\/span> untuk &#8220;kurang dari atau sama dengan&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktik dengan <span style=\"padding: 1px; border: 1px solid black;\">penjualan<\/span> koleksi dengan dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.sales.insertOne({day: new Date(\" <span style=\"color: #008000;\">2020-01-20<\/span> \"), amount: <span style=\"color: #ff0000;\">40<\/span> })<\/strong>\n<strong>db.sales.insertOne({day: new Date(\" <span style=\"color: #008000;\">2020-01-21<\/span> \"), amount: <span style=\"color: #ff0000;\">32<\/span> })<\/strong>\n<strong>db.sales.insertOne({day: new Date(\" <span style=\"color: #008000;\">2020-01-22<\/span> \"), amount: <span style=\"color: #ff0000;\">19<\/span> })<\/strong>\n<strong>db.sales.insertOne({day: new Date(\" <span style=\"color: #008000;\">2020-01-23<\/span> \"), amount: <span style=\"color: #ff0000;\">29<\/span> })<\/strong>\n<strong>db.sales.insertOne({day: new Date(\" <span style=\"color: #008000;\">2020-01-24<\/span> \"), amount: <span style=\"color: #ff0000;\">35<\/span> })<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Pencarian dokumen antara dua tanggal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menemukan semua dokumen yang kolom \u201charinya\u201d berada di antara dua tanggal tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.sales.find({\n    day: {\n        <span style=\"color: #3366ff;\">$gt<\/span> : ISODate(\" <span style=\"color: #008000;\">2020-01-21<\/span> \"),\n        <span style=\"color: #3366ff;\">$lt<\/span> : ISODate(\" <span style=\"color: #008000;\">2020-01-24<\/span> \")\n    }\n})<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan dua dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"618548bc7529c93ea0b41490\"),\n  day: 2020-01-22T00:00:00.000Z,\n  amount: 19 }\n\n{ _id: ObjectId(\"618548bc7529c93ea0b41491\"),\n  day: 2020-01-23T00:00:00.000Z,\n  amount: 29 }<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Mencari dokumen setelah tanggal tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menemukan semua dokumen yang kolom &#8220;hari&#8221;-nya setelah tanggal tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.sales.find({\n    day: {\n        <span style=\"color: #3366ff;\">$gt<\/span> : ISODate(\" <span style=\"color: #008000;\">2020-01-22<\/span> \")\n    }\n})<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan dua dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"618548bc7529c93ea0b41491\"),\n  day: 2020-01-23T00:00:00.000Z,\n  amount: 29 }\n\n{ _id: ObjectId(\"618548bc7529c93ea0b41492\"),\n  day: 2020-01-24T00:00:00.000Z,\n  amount: 35 }<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Mencari dokumen sebelum tanggal tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menemukan semua dokumen yang kolom &#8220;hari&#8221;-nya sebelum tanggal tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.sales.find({\n    day: {\n        <span style=\"color: #3366ff;\">$lt<\/span> : ISODate(\" <span style=\"color: #008000;\">2020-01-22<\/span> \")\n    }\n})<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan dua dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"618548bc7529c93ea0b4148e\"),\n  day: 2020-01-20T00:00:00.000Z,\n  amount: 40 }\n\n{ _id: ObjectId(\"618548bc7529c93ea0b4148f\"),\n  day: 2020-01-21T00:00:00.000Z,\n  amount: 32 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>ISODate()<\/strong> <a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/method\/Date\/\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan query umum lainnya di MongoDB:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-mirip-dengan-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara melakukan kueri dengan ekspresi reguler \u201cSuka\u201d.<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mongodb-berisi\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara memeriksa apakah bidang berisi string<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk melakukan kueri dengan rentang tanggal di MongoDB: db.collection.find({ day: { $gt : ISODate(&#8221; 2020-01-21 &#8220;), $lt : ISODate(&#8221; 2020-01-24 &#8220;) } }) Kueri khusus ini akan mengembalikan semua dokumen dalam koleksi yang bidang &#8220;harinya&#8221; lebih besar dari 21-01-2020 dan kurang dari 24-01-2020. Perhatikan bahwa $gt menunjukkan &#8220;lebih besar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MongoDB: Cara melakukan kueri dengan rentang tanggal - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menanyakan rentang tanggal di MongoDB, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB: Cara melakukan kueri dengan rentang tanggal - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menanyakan rentang tanggal di MongoDB, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T10:54:11+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/\",\"url\":\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/\",\"name\":\"MongoDB: Cara melakukan kueri dengan rentang tanggal - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T10:54:11+00:00\",\"dateModified\":\"2023-07-22T10:54:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menanyakan rentang tanggal di MongoDB, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: cara melakukan kueri dengan rentang tanggal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MongoDB: Cara melakukan kueri dengan rentang tanggal - Statorial","description":"Tutorial ini menjelaskan cara menanyakan rentang tanggal di MongoDB, dengan beberapa contoh.","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:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara melakukan kueri dengan rentang tanggal - Statorial","og_description":"Tutorial ini menjelaskan cara menanyakan rentang tanggal di MongoDB, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/","og_site_name":"Statorials","article_published_time":"2023-07-22T10:54:11+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/","url":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/","name":"MongoDB: Cara melakukan kueri dengan rentang tanggal - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T10:54:11+00:00","dateModified":"2023-07-22T10:54:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menanyakan rentang tanggal di MongoDB, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rentang-tanggal-kueri-mongodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: cara melakukan kueri dengan rentang tanggal"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2399"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2399"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2399\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}