MySQL CURDATE() function
May 15, 2021 MySQL
Table of contents
MySQL CURDATE() function
MySQL Date function
Definitions and usages
CURDATE() returns the current date.
Grammar
CURDATE()
Instance
Here's the SELECT statement:
SELECT NOW(),CURDATE(),CURTIME()
The result is as follows:
| NOW() | CURDATE() | CURTIME() |
|---|---|---|
| 2008-11-11 12:45:34 | 2008-11-11 | 12:45:34 |
Instance
The following SQL creates an "Orders" table with a date-time column:
CREATE TABLE Orders
(
OrderId int NOT NULL,
ProductName varchar(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT CURDATE(),
PRIMARY KEY (OrderId)
)
(
OrderId int NOT NULL,
ProductName varchar(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT CURDATE(),
PRIMARY KEY (OrderId)
)
Note that the OrderDate column specifies CURDATE() as the default. As a result, when you insert rows into a table, the current date and time are automatically inserted into the column.
Now, we want to insert a record in the Orders table:
INSERT INTO Orders (ProductName) VALUES ('Jarlsberg Cheese')
The Orders table will look like this:
| OrderId | ProductName | OrderDate |
|---|---|---|
| 1 | Jarlsberg Cheese | 2008-11-11 |
MySQL Date function