Msg 242, Level 16, State 3, Line 1
The conversion of a char data type DATETIME returned a value out of range for date and time.
The statement has been terminated.
Ya, it is something with the datetime. But that datetime is a valid datetime in the US. I think it may have something to do with how different countries write datetime.
See if this works:
Code:
SET DATEFORMAT YMD;
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(1,1,3,349,'AC_1000 75_1','2011-02-17 19:41:38');
What if you explicitly tell it the location of PointLog, like this?
Code:
SET DATEFORMAT YMD;
INSERT INTO PS_GameData.dbo.PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(1,1,3,349,'AC_1000 75_1','2011-02-17 19:41:38');
It looked like that worked then, so probably your SQL Server expects dates to be in some format other than YMD.
You can try adding
Code:
SET DATEFORMAT YMD;
into your [dbo].[usp_Save_User_BuyPointItems_NCash] stored procedure and it should fix that varchar to datetime conversion error you were getting there.
