DateTime in SQLServer and VB.net

Question

I am trying to write the current date into a database table. I have set the field of the table as 'date'. I am writing

DateTime.Now.Date.ToString as a parameter to the insert/update query. So, my code is something like:

cmd.CommandText = "update tab set dt = @d where id=1" cmd.Parameters.add("@d",DateTime.Now.Date.ToString)

This doesnt seem to be updating values in the database. Is something amiss here?

Oded · Accepted Answer · 2012-11-19 12:43:16Z

5

Don't pass in a string to something that expects a DATE.

Pass in the DateTime instance instead:

cmd.Parameters.AddWithValue("@d",DateTime.Now.Date)

answered Nov 19, 2012 at 12:43

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wjdavis5 · Accepted Answer · 2012-11-19 13:10:45Z

1

If this is SQL Server get remove the parameter and change the SPROC to use GETDATE() that will cause this to always insert the SQL Server's current DateTime Stamp.

answered Nov 19, 2012 at 13:10

Wjdavis5

4,2018 gold badges37 silver badges67 bronze badges

Collectives™ on Stack Overflow

DateTime in SQLServer and VB.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related