How to add automatic date in table column - How to insert automatic date in table column

Use 

SELECT GETDATE() //will give current date

 SELECT CAST(GETDATE() AS DATE) //will give only date