SQL Stored Procedure Call

, ,
1

Hi all,

We are STILL using IS 4.6 and we are trying to call a SQL 2000 Stored Procedure using CALL in pub.db. One of the input values to stored procedure is Datetime, when we call the sp with all the input values I am getting an error message
“[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Error converting data type nvarchar to datetime.”

Any body experienced this one, please help us figure this problem.

Thanks,
Muru.

2

Sounds like SQL Server can’t parse the format of the datetime-parameter. If you pass a datetime-value as string, SQL Server will try to parse this based on regional settings. In my experience the safest way to pass a date-string to SQL Server is as “yyyy-mm-dd hh:nn:ss”.

3

Martin,

Thats exactly how we are passing the date string. Here is the date format yyyy-MM-dd HH:mm:ss

Thanks,
Muru.