MySQL NOW () function
MySQL Date Functions Definition and Usage
NOW () returns the current date and time.
grammar
NOW()
Examples
Here is the SELECT statement:
SELECT NOW(),CURDATE(),CURTIME()
The results are as follows:
| NOW() | CURDATE() | CURTIME() |
|---|---|---|
| 2008-11-11 12:45:34 | 2008-11-11 | 12:45:34 |
Examples
The following SQL to create "Orders" table with a datetime column (OrderDate) of:
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)
)
Please note, OrderDate column specified NOW () as the default. As a result, when you insert a row into the table, the current date and time automatically inserted column.
Now, we want to insert a record into the "Orders" table:
INSERT INTO Orders (ProductName) VALUES ('Jarlsberg Cheese')
"Orders" table is as follows:
| OrderId | ProductName | OrderDate |
|---|---|---|
| 1 | Jarlsberg Cheese | 2008-11-11 13:23:44.657 |
MySQL Date Functions