1. This works :
select
2010-10-12
2. This doesnt work, because the string format is not compliant with the date format currently used by sql serverselect
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
3. The following will work : select
2010-10-12 CONVERT(date , cast('10-12-2010' as datetime ) , 102) CONVERT(date , '10-12-2010', 102) CONVERT(date , '2010-10-12' , 102)
Subscribe to:
Post Comments (Atom)
Vercel Mongo Integration
Click continue Press “I Acknowledge” Multiselect vercel projects Click “ “Connect and ...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
This error means you have created the DbContext but not configured/added it to the project using either DI in startup.cs or by using DbCon...
No comments:
Post a Comment