Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

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.


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/sql-server/date-time-functions.txt · Last modified: March 20, 2013, 04:09:32 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement