sql server - Difference between CURRENT_TIMESTAMP and GETDATE()

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/24226763/difference-between-current-timestamp-and-getdate

Answer 1

CURRENT_TIMESTAMP is an ANSI SQL function whereas GETDATE is the T-SQL version of that same function.

One interesting thing to note however, is that CURRENT_TIMESTAMP is converted to GETDATE() when creating the object within SSMS. Both functions retrieve their value from the operating system in the same way.

CURRENT_TIMESTAMP is the recommended usage because it is portable to any ANSI compliant database, where as GETDATE() is not.

EDIT - About performance - there is no difference between the two because SQL-SERVER engine is converting CURRENT_TIMESTAMP to GETDATE() so you are actually using GETDATE().

see here and here