User GETDATE() to put current date into SQL variable

Question

I'm trying to get the current date into a variable inside a SQL stored procedure using the following commands

DECLARE @LastChangeDate as date
SET @LastChangeDate = SELECT GETDATE()

This gives me the following error: "Incorrect Syntax near 'SELECT'"

This is the first stored procedure I've ever written, so I'm unfamiliar with how variables work inside SQL.

Answer 1

You don't need the SELECT

DECLARE @LastChangeDate as date
SET @LastChangeDate = GetDate()

Answer 2

Just use GetDate() not Select GetDate()

DECLARE @LastChangeDate as date 
SET @LastChangeDate = GETDATE() 

but if it's SQL Server, you can also initialize in same step as declaration...

DECLARE @LastChangeDate date = getDate()