Understanding the Current Date and Time in SQL Server: Demystifying CURRENT_TIMESTAMP and GETDATE()
Similarities:Both CURRENT_TIMESTAMP and GETDATE() return the current date and time as a datetime data type.They retrieve this value from the underlying operating system of the server without any arguments