getdate() mystery

manuavaran · #1 (**permalink**) 01-02-12, 02:36

when tried execute a stored procedure which uses getdate() function as a variable it produced error message like this
MSG 102, Level 15, State 1, Line 10
Incorrect syntax near ')'.
the query is given below

Quote:

GO
DECLARE @return_value int
EXEC @return_value = [dbo].[INSERT_CALLBACK_67]
@PHONE ='46346',
@CALLBACKTIMEORG = getdate(),
SELECT 'Return Value' = @return_value
GO

then i rewrite the query and executed by declaring getdate() function as given below, it gave correct result

Quote:

USE [testy5]
GO
DECLARE @return_value int
DECLARE @dt DATETIME;
SET @dt = GETDATE();
EXEC @return_value = [dbo].[INSERT_CALLBACK_67]
@PHONE = '6757866',
@CALLBACKTIMEORG = @dt,
SELECT 'Return Value' = @return_value
GO

why this is happening ,i would like know the concept behind

thanks in advance

PracticalProgram · #2 (**permalink**) 01-02-12, 07:55

Have you tried removing the comma after the getdate() in your first section of code?

manuavaran · #3 (**permalink**) 01-02-12, 22:54

Dear kenn,
thanku for ur fast reply.
sorry for the comma problem,actually it was not there in my code. i removed comma, tried agan..
the same results

i will qoute the code again

Quote:

GO
DECLARE @return_value int
EXEC @return_value = [dbo].[INSERT_CALLBACK_67]
@PHONE ='46346',
@CALLBACKTIMEORG = getdate()
SELECT 'Return Value' = @return_value
GO

Pat Phelan · #4 (**permalink**) 01-03-12, 00:11

The parameters in an EXECUTE statement must be a value or a variable. Parameters for MS-SQL User Defined functions can be expressions such as GetDate().

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech