Table of Contents
Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
SQL Server - Date and Time Functions
This article describes the Transact-SQL date and time functions supported by Microsoft SQL Server.
Overview
Function | Description |
---|---|
GETDATE() | Returns the current system date and time. |
GETDATE
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. |