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

User · Answer

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

User · Answer

You don t need the SELECT  DECLARE  LastChangeDate as date SET  LastChangeDate   GetDate

User · Answer

SELECT  LastChangeDate   GETDATE

User · Answer

DECLARE  LastChangeDate as date  SET  LastChangeDate   GETDATE

User · Answer

You can also use CURRENT TIMESTAMP for this    According to BOL CURRENT TIMESTAMP is the ANSI SQL euivalent to GETDATE    DECLARE  LastChangeDate AS DATE  SET  LastChangeDate   CURRENT TIMESTAMP

[sql] User GETDATE() to put current date into SQL variable

Examples related to sql

Examples related to tsql