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