Creating a SqlDbType.SmallDateTime parameter

[digsy_]

I'm trying to create a SqlDbType.SmallDateTime parameter and have been unable to find the correct answer. I'm trying to take a date in mm/dd/yyyy format from a text box and pass it to a stored procedure. This is about as close I have got but it still doesnt work: SelectCommand.Parameters.Add("@dateofbirth", SqlDbType.SmallDateTime).Value = DateTime.Parse(StoredProcedureValues[3]).ToShortDateString(); Does anyone know what the answer is ? Thanks

[Marcus J Smith]

When you are adding a datetime value of any sort to a database leave it in a date, I mean DATE, format if possible. Otherwise you must format it correctly to insert. So ensure that the value you are parsing to DateTime is a date value and dont set it to short date string. SmallDateTime is about precision not how it looks in the DB[^]

---

CleaKO

"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)