How to get the date in a sql statement (TSQL)

To get the date in a select statement, stored procedure, etc. You can use the getdate() function.
For example, you can do

Select getdate()