how to add curret date to sql table code example

Example: sql display today's date

SELECT getdate()