TimeStamp , {"Failed to convert parameter value from a DateTime to a Byte[]."}

Question

getting the error

{"Failed to convert parameter value from a DateTime to a Byte[]."}

i have tried time-stamp but getting the error

cmd.Parameters.Add("@DATETIME", SqlDbType.Timestamp).Value = DateTime.Now;

possible duplicate of [Failed to convert parameter value from a DateTime to a Byte\[\]](http://stackoverflow.com/questions/9364319/failed-to-convert-parameter-value-from-a-datetime-to-a-byte) — C.Evenhuis, Jun 02 '14 at 08:10

score 1 · Answer 1 · answered Jun 02 '14 at 08:10

1

If you want to assign DateTime to parameter's value, change its type to SqlDbType.DateTime.

answered Jun 02 '14 at 08:10

SoftwareFactor

score 0 · Accepted Answer · edited May 23 '17 at 11:57

0

Sql server's timestamp is not a date/time, so you can't convert it to a datetime and vice versa.

See a detailed explanation here

Use datetime instead.

edited May 23 '17 at 11:57

Community

answered Jun 02 '14 at 08:10

Lee

2 Answers2