Data type/Varchar error

Question

I'm trying to insert in my database (SQL Server 2012) a date (dd/MM/yyyy) from a DateTimePicker. When I checked my database, the format has been saved like (yyyy/dd/MM), the problem is when I choose a day between 13 and the last day of the month, I got the message "error converting data type varchar to datetime". But if I choose a day between 01 and 12, it works.

My class is something like this:

public class Example
{
   private SqlDateTime date;

   public SqlDateTime date
   {
      get {return date;}
      set {date = value;}
   }
}

And the object that is getting my date is:

  Example example = new Example();
  example.date = SqlDatime.Parse(dateTimePicker.Value.Date);

My query just takes the (example.date) and insert it in the database. Any idea?

Thanks in advance, and sorry about my english

why are you using *SqlDateTime*, why not just simple `DateTime` and I think data type in table should be `datetime` instead of `varchar` — Sachin, Nov 14 '13 at 14:06
@sachin: there ARE reasons for use of SqlDateTime: here on stackoverlfow: http://stackoverflow.com/questions/19018600/datetime-issue-in-sql-server explains a little. — nabuchodonossor, Nov 14 '13 at 14:23
@Anderson what happens if you use example.date = dateTimePicker.Value — abhi, Nov 14 '13 at 14:55
BDW `SqlDatime` should be `SqlDateTime` in `example.date = SqlDatime.Parse(dateTimePicker.Value.Date);` — Sahil Sareen, Nov 14 '13 at 18:33

score 0 · Answer 1 · answered Nov 14 '13 at 15:02

0

At least when I had this problem, I solved by formatting the date as yyyy-MM-dd and it solved for a Datetime field in SQL. Try this :

Example example = new Example();
example.date = dateTimePicker.Value.Date.ToString("yyyy-MM-dd");

answered Nov 14 '13 at 15:02

André Silva

1,149
9
30

score 0 · Answer 2 · answered Nov 14 '13 at 18:35

0

Use : dateTimePicker.Value.Date.ToString("yyyy-MM-dd HH:mm:ss");

answered Nov 14 '13 at 18:35

Sahil Sareen

1,813
3
25
40

Data type/Varchar error

2 Answers2