{"id":136,"date":"2023-07-22T12:49:44","date_gmt":"2023-07-22T12:49:44","guid":{"rendered":"http:\/\/local.tutorials\/?post_type=topic&#038;p=136"},"modified":"2023-07-22T12:49:47","modified_gmt":"2023-07-22T12:49:47","slug":"mysql-dates","status":"publish","type":"topic","link":"http:\/\/local.tutorials\/topic\/mysql-dates\/","title":{"rendered":"MySQL Dates"},"content":{"rendered":"\n<p>In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Date Data Type:<\/strong><\/h2>\n\n\n\n<p>MySQL provides the <code>DATE<\/code> data type to store date values. To create a table with a date column, you can use the <code>DATE<\/code> data type like this:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">CREATE TABLE events (\n    event_id INT PRIMARY KEY,\n    event_name VARCHAR(100),\n    event_date DATE\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Inserting Date Values:<\/strong><\/h2>\n\n\n\n<p>To insert date values into the &#8220;events&#8221; table, use the following format: &#8216;YYYY-MM-DD&#8217;. For example:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">INSERT INTO events (event_id, event_name, event_date) VALUES\n(1, &#039;Meeting&#039;, &#039;2023-07-15&#039;),\n(2, &#039;Conference&#039;, &#039;2023-09-20&#039;),\n(3, &#039;Workshop&#039;, &#039;2023-08-10&#039;);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Date Functions:<\/strong><\/h2>\n\n\n\n<p>MySQL provides a range of date functions to work with date values. For instance:<\/p>\n\n\n\n<ul>\n<li><code>NOW()<\/code>: Returns the current date and time.<\/li>\n\n\n\n<li><code>CURDATE()<\/code>: Returns the current date.<\/li>\n\n\n\n<li><code>DATE_ADD(date, INTERVAL value unit)<\/code>: Adds a specific interval to a date.<\/li>\n\n\n\n<li><code>DATE_SUB(date, INTERVAL value unit)<\/code>: Subtracts a specific interval from a date.<\/li>\n\n\n\n<li><code>DATEDIFF(end_date, start_date)<\/code>: Calculates the difference between two dates in days.<\/li>\n<\/ul>\n\n\n\n<p>Here&#8217;s an example of using some date functions:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SELECT NOW(); -- Current date and time\nSELECT CURDATE(); -- Current date\nSELECT DATE_ADD(CURDATE(), INTERVAL 7 DAY); -- Date 7 days from today\nSELECT DATE_SUB(CURDATE(), INTERVAL 1 MONTH); -- Date 1 month ago\nSELECT DATEDIFF(&#039;2023-09-15&#039;, &#039;2023-07-15&#039;); -- Difference between two dates<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formatting Dates:<\/strong><\/h2>\n\n\n\n<p>You can use the <code>DATE_FORMAT()<\/code> function to format dates into a specific string format. For example:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SELECT event_name, DATE_FORMAT(event_date, &#039;%M %d, %Y&#039;) AS formatted_date\nFROM events;<\/code><\/pre>\n\n\n\n<p>This query will display the event names along with the formatted date in the format &#8216;Month day, Year&#8217;.<\/p>\n\n\n\n<p>MySQL offers extensive date and time functions to handle various scenarios, including date arithmetic, date comparisons, and date manipulation. Always ensure that you are using the appropriate functions for your specific requirements and that you understand the date format used in your MySQL server. Additionally, consider timezone considerations if your application needs to deal with date and time in different time zones.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL. Date Data Type: MySQL provides the DATE data type to store date values. To create a table with a date column, you can use the DATE data type [&hellip;]<\/p>\n","protected":false},"featured_media":45,"comment_status":"open","ping_status":"closed","template":"","meta":[],"categories":[3],"tags":[],"subject":[16,18],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Dates Overview<\/title>\n<meta name=\"description\" content=\"In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.tutorials\/topic\/mysql-dates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Dates Overview\" \/>\n<meta property=\"og:description\" content=\"In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.tutorials\/topic\/mysql-dates\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com Tutorials and Courses\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-22T12:49:47+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.tutorials\/wp-content\/uploads\/2022\/03\/tutorial-mysql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.tutorials\/topic\/mysql-dates\/\",\"url\":\"http:\/\/local.tutorials\/topic\/mysql-dates\/\",\"name\":\"MySQL Dates Overview\",\"isPartOf\":{\"@id\":\"http:\/\/local.tutorials\/#website\"},\"datePublished\":\"2023-07-22T12:49:44+00:00\",\"dateModified\":\"2023-07-22T12:49:47+00:00\",\"description\":\"In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL\",\"breadcrumb\":{\"@id\":\"http:\/\/local.tutorials\/topic\/mysql-dates\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.tutorials\/topic\/mysql-dates\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.tutorials\/topic\/mysql-dates\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.tutorials\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"http:\/\/local.tutorials\/topic\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL Dates\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.tutorials\/#website\",\"url\":\"http:\/\/local.tutorials\/\",\"name\":\"Brightwhiz.com Tutorials and Courses\",\"description\":\"\",\"publisher\":{\"@id\":\"http:\/\/local.tutorials\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.tutorials\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.tutorials\/#organization\",\"name\":\"Brightwhiz.com\",\"url\":\"http:\/\/local.tutorials\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.tutorials\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/staging.brightwhiz.com\/wp-content\/uploads\/2022\/03\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"https:\/\/staging.brightwhiz.com\/wp-content\/uploads\/2022\/03\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz.com\"},\"image\":{\"@id\":\"http:\/\/local.tutorials\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\",\"https:\/\/twitter.com\/brightwhizmag\",\"https:\/\/www.instagram.com\/glamorglaze\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/c\/Sobbayi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Dates Overview","description":"In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL","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":"http:\/\/local.tutorials\/topic\/mysql-dates\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Dates Overview","og_description":"In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL","og_url":"http:\/\/local.tutorials\/topic\/mysql-dates\/","og_site_name":"Brightwhiz.com Tutorials and Courses","article_publisher":"https:\/\/www.facebook.com\/brightwhiz","article_modified_time":"2023-07-22T12:49:47+00:00","og_image":[{"width":640,"height":360,"url":"http:\/\/local.tutorials\/wp-content\/uploads\/2022\/03\/tutorial-mysql.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@brightwhizmag","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/local.tutorials\/topic\/mysql-dates\/","url":"http:\/\/local.tutorials\/topic\/mysql-dates\/","name":"MySQL Dates Overview","isPartOf":{"@id":"http:\/\/local.tutorials\/#website"},"datePublished":"2023-07-22T12:49:44+00:00","dateModified":"2023-07-22T12:49:47+00:00","description":"In MySQL, you can work with dates using various date and time functions and data types. Here are some examples of how to use dates in MySQL","breadcrumb":{"@id":"http:\/\/local.tutorials\/topic\/mysql-dates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.tutorials\/topic\/mysql-dates\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/local.tutorials\/topic\/mysql-dates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.tutorials\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"http:\/\/local.tutorials\/topic\/"},{"@type":"ListItem","position":3,"name":"MySQL Dates"}]},{"@type":"WebSite","@id":"http:\/\/local.tutorials\/#website","url":"http:\/\/local.tutorials\/","name":"Brightwhiz.com Tutorials and Courses","description":"","publisher":{"@id":"http:\/\/local.tutorials\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.tutorials\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.tutorials\/#organization","name":"Brightwhiz.com","url":"http:\/\/local.tutorials\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.tutorials\/#\/schema\/logo\/image\/","url":"https:\/\/staging.brightwhiz.com\/wp-content\/uploads\/2022\/03\/brightwhiz-com-logo-orange.png","contentUrl":"https:\/\/staging.brightwhiz.com\/wp-content\/uploads\/2022\/03\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz.com"},"image":{"@id":"http:\/\/local.tutorials\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz","https:\/\/twitter.com\/brightwhizmag","https:\/\/www.instagram.com\/glamorglaze\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/c\/Sobbayi"]}]}},"_links":{"self":[{"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/topic\/136"}],"collection":[{"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/types\/topic"}],"replies":[{"embeddable":true,"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/comments?post=136"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/media\/45"}],"wp:attachment":[{"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/tags?post=136"},{"taxonomy":"subject","embeddable":true,"href":"http:\/\/local.tutorials\/wp-json\/wp\/v2\/subject?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}