Returns the current date and time.
GETDATE ()
The following statement returns the system date and time.
SELECT GETDATE( ) FROM iq_dummy
GETDATE is a Transact-SQL compatible data manipulation function.
SQL92 Vendor extension
Sybase Compatible with Adaptive Server Enterprise