SQL Server GETDATE () function
SQL Server Date Functions Definition and Usage
GETDATE () function returns the current date and time from the SQL Server.
grammar
GETDATE()
Examples
Here is the SELECT statement:
SELECT GETDATE() AS CurrentDateTime
The results are as follows:
| CurrentDateTime |
|---|
| 2008-11-11 12:45:34.243 |
NOTE: The above part time to the millisecond.
Examples
The following SQL to create "Orders" table with a datetime column (OrderDate) of:
CREATE TABLE Orders
(
OrderId int NOT NULL PRIMARY KEY,
ProductName varchar(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT GETDATE()
)
(
OrderId int NOT NULL PRIMARY KEY,
ProductName varchar(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT GETDATE()
)
Please note, OrderDate column specified CURDATE () 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 |
SQL Server Date Functions