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