Set variable to current date in stored procedure 2

[hblabonte]

This may seem like a simple one. I've got a datetime variable that I'm declaring in a stored procedure. How do I set it to be the current date?

(
@today datetime=Now
)

This gives me a "syntax error converting datetime from a character string."

thanks in advance,
H. Barnes

 

[AWithers]

I think the correct syntax would be 'getdate'

e.g.

@today datetime = getdate

Andy

 

[RichS]

try:

declare @today datetime
select @today = getdate()
select @today