CURRENT_TIMESTAMP Date Function TSQL Tutorial

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