Getting the error:
Conversion failed when converting date and/or time from character string.
I m trying to get a date value from user and save it in datetime datatype in SQL Server.
But getting this error. Please help.
Asked
Active
Viewed 41 times
0
-
You can tell by the colorization of the string that you're missing quotes around `onedate` – Rufus L Jan 13 '20 at 10:50
-
[Little Bobby Tables](https://bobby-tables.com/) alert! – Uwe Keim Jan 13 '20 at 10:54
-
Works if I add quotes but if i select future dates gives the below error - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. – Ruchi Jan 13 '20 at 11:03
-
Y I read it but I need to add datetime values from date time picker in c# – Ruchi Jan 13 '20 at 13:43
-
Please read the duplicate link. It will work for you. – mjwills Jan 13 '20 at 20:39