{"id":6194,"date":"2017-07-08T01:50:53","date_gmt":"2017-07-08T08:50:53","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=6194"},"modified":"2024-01-05T19:30:57","modified_gmt":"2024-01-06T02:30:57","slug":"mysql-today","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-today\/","title":{"rendered":"How to Get MySQL Today’s Date"},"content":{"rendered":"
\n
\"MySQL<\/figure>\n<\/div>\n\n\n

Summary<\/strong>: in this tutorial, you will learn how to query data that matches MySQL today<\/strong>‘s date by using built-in date functions.<\/p>\n\n\n\n

Getting MySQL today’s date using built-in date functions<\/h2>\n\n\n\n

Sometimes, you may want to query data from a table to get rows with the date column\u00a0is today, for example:<\/p>\n\n\n

SELECT<\/span> \n    column_list\nFROM<\/span>\n    table_name\nWHERE<\/span>\n    expired_date = today;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To get today’s date, you use the CURDATE()<\/code> function as follows:<\/p>\n\n\n
mysql> SELECT<\/span> CURDATE<\/span>() today;\n+------------+<\/span>\n| today      |\n+------------+<\/span>\n| 2017-07-08 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Alternatively, you can get the date part from the current time returned by the NOW()<\/a><\/code> function:<\/p>\n\n\n
mysql> SELECT<\/span> DATE<\/span>(NOW<\/span>()) today;\n+------------+<\/span>\n| today      |\n+------------+<\/span>\n| 2017-07-08 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
So the query should change to:<\/p>\n\n\n
SELECT<\/span> \n    column_list\nFROM<\/span>\n    table_name\nWHERE<\/span>\n    expired_date = CURDATE<\/span>();<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
If the expired_date<\/code> column contains both the date and time part, you should use the DATE()<\/code> function to extract only the date part and compare it with the current date:<\/p>\n\n\n
SELECT<\/span> \n    column_list\nFROM<\/span>\n    table_name\nWHERE<\/span>\n    DATE<\/span>(expired_date) = CURDATE<\/span>();<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Creating your MySQL today stored function<\/h2>\n\n\n\n
If you use frequently the CURDATE()<\/code><\/a> function in your queries and want to replace them with the today()<\/code> function for enhanced readability, you can create your own stored function<\/a> named today()<\/code> as follows:<\/p>\n\n\n
DELIMITER $$\n\nCREATE<\/span> FUNCTION<\/span> today()\nRETURNS<\/span> DATE<\/span>\nDETERMINISTIC<\/span>\nBEGIN<\/span>\n   RETURN<\/span> CURDATE<\/span>();\nEND<\/span>$$\n\nDELIMITER ;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Now, you can use the today()<\/code> function as follows:<\/p>\n\n\n
SELECT today();<\/code><\/span><\/pre>\n\n\n
Output:<\/p>\n\n\n
+------------+<\/span>\n| today()    |\n+------------+<\/span>\n| 2017-07-08 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
How about tomorrow? It should be as simple as the following query:<\/p>\n\n\n
SELECT today() + interval 1 day Tomorrow;<\/code><\/span><\/pre>\n\n\n
Output:<\/p>\n\n\n
+------------+<\/span>\n| Tomorrow   |\n+------------+<\/span>\n| 2017-07-09 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
And also yesterday is easy as well:<\/p>\n\n\n
SELECT today() - interval 1 day Yesterday;<\/code><\/span><\/pre>\n\n\n
Output:<\/p>\n\n\n
+------------+<\/span>\n| Yesterday  |\n+------------+<\/span>\n| 2017-07-07 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Getting employees whose birthday is today<\/h2>\n\n\n\n
Sometimes, you want to retrieve employees whose birthday is today. Let’s see an example.<\/p>\n\n\n\n
First, create a table called employees<\/code>:<\/p>\n\n\n
CREATE TABLE employees (\r\n    id INT AUTO_INCREMENT PRIMARY KEY,\r\n    name VARCHAR(255<\/span>) NOT NULL<\/span>,\r\n    birthday DATE NOT NULL<\/span>\r\n);<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Second, insert some rows into the employees<\/code> table:<\/p>\n\n\n
INSERT INTO employees (name, birthday) \nVALUES\r\n    ('John Doe'<\/span>, '1990-01-06'<\/span>),\r\n    ('Jane Smith'<\/span>, '1985-08-22'<\/span>),\r\n    ('Bob Johnson'<\/span>, '1993-03-10'<\/span>),\r\n    ('Alice Brown'<\/span>, '1988-11-05'<\/span>),\r\n    ('Charlie White'<\/span>, '1995-07-18'<\/span>),\r\n    ('Eva Davis'<\/span>, '1982-09-30'<\/span>),\r\n    ('Mike Miller'<\/span>, '1998-01-25'<\/span>),\r\n    ('Sarah Jones'<\/span>, '1987-06-12'<\/span>),\r\n    ('David Taylor'<\/span>, '1991-12-08'<\/span>),\r\n    ('Emily Wilson'<\/span>, '1984-04-03'<\/span>);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Third, find the employees whose birthday is today:<\/p>\n\n\n
SELECT *\r\nFROM employees\r\nWHERE DAY(birthday) = DAY(CURDATE()) \n      AND MONTH(birthday) = MONTH(CURDATE());<\/code><\/span><\/pre>\n\n\n
The query retrieves employees whose month and day of birthday are the same as the month and day of today.<\/p>\n\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the CURDATE()<\/code> or NOW()<\/code> function to return the today’s date.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t