Skip to Content
0
Former Member
Jul 06, 2006 at 03:15 PM

Data TYPE that corresponds to Datetime of SQL

1378 Views

Hi,

I am getting a Database error 8114 at EXE "Error Converting nvarchar to datetime" when calling a stored procedure on SQL Database using Native SQL command within EXEC SQL / ENDEXEC. The problem is from one of the IN Parameters of the Stored Procedure that is of a SQL datatype DATETIME. I have tried to pass value to this DATETIME parameter using the ABAP variable of type C and D and still getting the same error.

Can anyone tell me what would be the right date type to use in ABAP in this case.

Thank you.