T-SQL Tutorial

CURRENT_TIMESTAMP Date Function


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