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.

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