{"id":14064,"date":"2024-03-15T08:23:42","date_gmt":"2024-03-15T08:23:42","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/"},"modified":"2025-08-06T03:14:52","modified_gmt":"2025-08-06T03:14:52","slug":"how-to-query-data-for-the-current-day-using-mybatis","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/","title":{"rendered":"MyBatis Current Date Query: CURDATE() Guide"},"content":{"rendered":"

To query data for the current day in MyBatis, you can use the CURDATE() function in MySQL to retrieve the current date, and then pass this value to the query statement.<\/p>\n

Here is an example of a Mapper interface method and its corresponding XML configuration file:<\/p>\n

    \n
  1. Mapper interface method:<\/li>\n<\/ol>\n
    public<\/span> List<YourEntity> selectByCurrentDate<\/span>()<\/span>;\r\n<\/code><\/pre>\n
      \n
    1. XML configuration file:<\/li>\n<\/ol>\n
      <select<\/span> id<\/span>=\"selectByCurrentDate\"<\/span> resultType<\/span>=\"YourEntity\"<\/span>><\/span>\r\n  SELECT * FROM your_table\r\n  WHERE date_column = CURDATE()\r\n<\/select<\/span>><\/span>\r\n<\/code><\/pre>\n
      In the example above, YourEntity is a custom entity class defined by you, your_table is the name of the table you want to query, and date_column is the name of the column containing dates that you want to query.<\/p>\n
      By using this method, you can retrieve the data for the current day.<\/p>\n","protected":false},"excerpt":{"rendered":"
      To query data for the current day in MyBatis, you can use the CURDATE() function in MySQL to retrieve the current date, and then pass this value to the query statement. Here is an example of a Mapper interface method and its corresponding XML configuration file: Mapper interface method: public List<YourEntity> selectByCurrentDate(); XML configuration file: […]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[6658,2688,1459,15617,3134],"class_list":["post-14064","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-date-query","tag-java-persistence","tag-mybatis","tag-mysql-curdate","tag-sql-mapping"],"yoast_head":"\nMyBatis Current Date Query: CURDATE() Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to query current day data in MyBatis using MySQL CURDATE(). Includes mapper interface & XML configuration examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyBatis Current Date Query: CURDATE() Guide\" \/>\n<meta property=\"og:description\" content=\"Learn to query current day data in MyBatis using MySQL CURDATE(). Includes mapper interface & XML configuration examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T08:23:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T03:14:52+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"MyBatis Current Date Query: CURDATE() Guide\",\"datePublished\":\"2024-03-15T08:23:42+00:00\",\"dateModified\":\"2025-08-06T03:14:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\"},\"wordCount\":112,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Date query\",\"Java persistence\",\"MyBatis\",\"MySQL CURDATE\",\"SQL mapping\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\",\"name\":\"MyBatis Current Date Query: CURDATE() Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T08:23:42+00:00\",\"dateModified\":\"2025-08-06T03:14:52+00:00\",\"description\":\"Learn to query current day data in MyBatis using MySQL CURDATE(). Includes mapper interface & XML configuration examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyBatis Current Date Query: CURDATE() Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MyBatis Current Date Query: CURDATE() Guide - Blog - Silicon Cloud","description":"Learn to query current day data in MyBatis using MySQL CURDATE(). Includes mapper interface & XML configuration examples.","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:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/","og_locale":"en_US","og_type":"article","og_title":"MyBatis Current Date Query: CURDATE() Guide","og_description":"Learn to query current day data in MyBatis using MySQL CURDATE(). Includes mapper interface & XML configuration examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T08:23:42+00:00","article_modified_time":"2025-08-06T03:14:52+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"MyBatis Current Date Query: CURDATE() Guide","datePublished":"2024-03-15T08:23:42+00:00","dateModified":"2025-08-06T03:14:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/"},"wordCount":112,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Date query","Java persistence","MyBatis","MySQL CURDATE","SQL mapping"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/","name":"MyBatis Current Date Query: CURDATE() Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T08:23:42+00:00","dateModified":"2025-08-06T03:14:52+00:00","description":"Learn to query current day data in MyBatis using MySQL CURDATE(). Includes mapper interface & XML configuration examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-for-the-current-day-using-mybatis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MyBatis Current Date Query: CURDATE() Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14064","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=14064"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14064\/revisions"}],"predecessor-version":[{"id":158081,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14064\/revisions\/158081"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}