CODEWITHSUNDEEP
c#sqlvisual-studio-2010
Hossein Hadavi
Hossein Hadavi

Reputation: 261

how to manually set data for a column in database which has "Datetime" type?

I have a column in my database which its type is date.

Now I want to manually fill the database. Actually the problem is when I manually type 13/8/2013, it alerts

the value in this cell is not known as "Datetime"

How can I manually set this column?

Upvotes: 0

Views: 97

Answers (2)

Ahmed Alaa El-Din
Ahmed Alaa El-Din

Reputation: 1833

you can do it like this: 2013-08-11 00:00:00.000 (YYYY-MM-dd hh:mm:ss:mmm)

Upvotes: 1

juergen d
juergen d

Reputation: 204766

Date format is yyyy-MM-dd.

2013-08-13

BTW from the error message it looks like the column type is datetime and not date.

Upvotes: 1

Related Questions