Error converting data type nvarchar to datetime SQL Server

0 votes

I encountered this error:

Error converting data type nvarchar to datetime

When inputting a date in the format of 26/01/2017 as a string literal. I'm inserting using this code in SQL Server: 

CONVERT(DATETIME, @PaymentDate, 104)

Can someone please help me with this?

Aug 15, 2022 in Database by Kithuzzz
• 38,010 points
2,900 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers

SQL Server : Arithmetic overflow error converting expression to data type int

I'm getting this error: msg 8115, level 16, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
887 views
0 votes
1 answer
0 votes
0 answers

Login to Microsoft SQL Server Error: 18456

When I try to connect to the SQL ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
• 38,010 points
479 views
0 votes
0 answers
0 votes
1 answer

Authenticate on an ASP.Net Forms Authorization website from a console app

Essentially, we need to record a regular ...READ MORE

answered Sep 20, 2018 in IoT (Internet of Things) by Annie97
• 2,160 points
642 views
0 votes
1 answer

Writing SEO friendly url gets infinite loop asp.net

you should know that regex avoid cases ...READ MORE

answered Feb 11, 2022 in Others by narikkadan
• 63,700 points
664 views
0 votes
0 answers

How to get Bitcoin value for corresponding USD value in ASP.NET C#?

I want to get the Bitcoin value ...READ MORE

Mar 1, 2022 in Blockchain by Soham
• 9,700 points
695 views
0 votes
0 answers

The request was aborted: Could not create SSL/TLS secure channel

When I connect to an  HTTPS server ...READ MORE

May 1, 2022 in Other DevOps Questions by Kichu
• 19,050 points
1,799 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP