SQL Server has a number of built-in functions that can be used to retrieve the current date in various formats. The following is a list
Tag: CURRENT_TIMESTAMP in SQL Server
SQL Server – GETDATE(), CURRENT_TIMESTAMP in DEFAULT statements
Most of the transactional tables generally do require to have a column with DEFAULT value as current date time to identify when the transaction had
Big Data & SQL 