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,000 points • 3,498 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,000 points • 1,178 views
0 votes
1 answer

Error: Cannot connect to the SQL Server on Ubuntu from SSMS - installing mssql on linux

Hey @Rajni, Verify if the server is running ...READ MORE

answered Mar 17, 2019 in Database by Anvit
 • 2,622 views
0 votes
0 answers

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This is my Stored procedure : CREATE PROCEDURE ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 7,371 views
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,000 points • 642 views
0 votes
0 answers

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

I am at a loss with one ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,463 views
0 votes
0 answers

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

I can't seem to link from a ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 2,070 views
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 • 950 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,600 points • 816 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,710 points • 828 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,040 points • 2,028 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.