Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using CONVERT() function
Message
From
07/02/2019 14:06:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01666022
Message ID:
01666060
Views:
31
>
>I see your point. But I can't find where I am messing up.
>In short:
>the XML is populated in the ASP.NET method. Where each element of the XML is a value. The problem is that when the value for the dreaded TARG_DATE is '13/02/2019 ...' (note 13!) somewhere my code looks at this as an american date. But there is no month 13. And the error comes from the stored procedure (which I described above). But even when I comment what I think is "offending" line in the stored procedure, I still get an error.
>I am sure it is me.

How do you populate that XML? I think the problem lies in there. With a proper XML serialization TARG_DATE would never be 13/02/2019 nor 02/13/2019. And also it might help to see the SP code.
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform