SQLWays Product Page - Migration to SQL Server
Free Evaluation
This article describes the Transact-SQL date and time functions supported by Microsoft SQL Server.
| Function | Description |
|---|---|
| GETDATE() | Returns the current system date and time. |
| SQL Server - GETDATE | |
|---|---|
| Syntax | GETDATE() |
| Parameter | The function requires no arguments. |
| Description | Returns the current system date and time. |
| Return Type | DATETIME |
| Notice | GETDATE is a nondeterministic function. Views and expressions that reference this column cannot be indexed. Date functions can be used in the SELECT statement select list or in the WHERE clause of a query. |
Equivalents in Other Databases
| Database | Equivalent |
|---|---|
| Oracle | SYSDATE - Returns the current date and time. |
SQLWays Product Page - Migration to SQL Server
Free Evaluation
Discussion