Problem inserting dates to SQL Server

  • Thread starter Thread starter RP
  • Start date Start date
I have a DateTimePicker with format dd-MM-yyyy. While attempting to
insert this date in SQL Server Date column, following exception is
thrown:

The conversion of a char data type to a datetime data type resulted in
an out-of-range datetime value.

Please help.
Click to expand...

Also be aware that SQL Server will likely throw the same error if
given a datetime earlier than 1 Jan 1732
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Date to appropriate format 4
Insert query crash(sql server), Date time format, server is not accepting 1
Inserting the datetime with milliseconds value into a datarow 6
String to DateTime 1
Error converting dd/MM/yyyy to sql server format 3
datetime type in SQL Server 2008 7
DateTime problem 11
How to convert a date string to datetime value with custom date format? 1

Back
Top