SQL Server GETDATE()Function
SQL Server Date Functions
Definition and Usage
The GETDATE() function returns the current date and time from SQL Server.
Syntax
GETDATE()
Example
The following is the SELECT statement:
SELECT GETDATE() AS CurrentDateTime
The result is as follows:
| CurrentDateTime |
|---|
| 2008-11-11 12:45:34.243 |
Note:The time part above is accurate to milliseconds.
Example
The following SQL creates an "Orders" table with a datetime column (OrderDate):
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 that the OrderDate column specifies CURDATE() as the default value. As a result, when you insert a row into the table, the current date and time are automatically inserted into the column.
Now, we want to insert a record into 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 |
SQL Server Date Functions Other Extensions