https://bornsql.ca/blog/dates-times-sql-server-t-sql-functions-get-current-date-time/
Dates and Times in SQL Server: T-SQL functions to get the current date and time