THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULARJS XML MORE FORUM EXAMPLES REFERENCES

SQL Server CURRENT_TIMESTAMP Function

❮ SQL Server Functions

Example

Return the current date and time:

SELECT CURRENT_TIMESTAMP;
Try it Yourself »

Definition and Usage

The CURRENT_TIMESTAMP function returns the current date and time, in a 'YYYY-MM-DD hh:mm:ss.mmm' format.

Tip: See also the GETDATE() function. 

Syntax

CURRENT_TIMESTAMP

Technical Details

Works in: SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005

❮ SQL Server Functions