sql-serverdatetimegetdate

Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()

Using SQL Server, which is the fastest or best practice method to use for date retrieval? Is there a difference between CURRENT_TIMESTAMP and GetDate()?

Solution

  • CURRENT_TIMESTAMP is standard ANSI SQL, and so is theoretically one tiny little island of 'don't need to change' amongst your thousands of SQL Server-specific lines of SQL if you ever need to move databases....