Calling a stored proc with GetDate() as a parameter
Posted on 2004-04-16
I have a stored procedure written that accepts 2 datetime fields as parameters.
It works fine if I use real dates. i.e.:
exec updateduration '4-1-2004', '4-1-2004'
I want to call it using getdate() but it won't work.. why not?
i.e. : exec updateduration getdate(), getdate()
Line 1: Incorrect syntax near ')'.