MySQL NOW() function
May 15, 2021 MySQL
Table of contents
MySQL NOW() function
MySQL Date function
Definitions and usages
NOW() returns the current date and time.
Grammar
NOW()
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 NOW(),
PRIMARY KEY (OrderId)
)
(
OrderId int NOT NULL,
ProductName varchar(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT NOW(),
PRIMARY KEY (OrderId)
)
Note that the OrderDate column specifies NOW() 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 13:23:44.657 |
MySQL Date function