SQL GETDATE Function
SQL > SQL Date Functions >
The GETDATE function is used to retrieve the current database system time in SQL Server. A common use of GETDATE is to get today's date.
The syntax for the GETDATE function is,
GETDATE does not require any argument.
The SQL statement,
SELECT GETDATE( );
produces the following result when run on March 15, 2000, at 00:05:02.123 AM.
GETDATE function is most useful when we need to record the time a particular transaction happens. In SQL Server, we simply insert the value of the GETDATE( ) function into the table to achieve this. We can also set the default value of a column to be GETDATE( ) to achieve the same purpose.
The Oracle and MySQL equivalent of GETDATE is SYSDATE.
List of SQL Date Functions