Return the current date and time of system.
CURRENT_TIMESTAMP Syntax:
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP Example:
SELECT 'The current timestamp is: '+ CONVERT(char(25),
CURRENT_TIMESTAMP) as System_date;
System_date |
---|
The current timestamp is: Jan 27 2014 10:33PM |