Updating date/time from VB.NET to SQL

Update meaning SQL already has Date/Time data?
you just want a update Date only?

xrok, correct. There is a value already in the table and I just want to update the date

You need pull data from SQL  then replace date with textbox.
using same time

Basic
dim sqldate as datetime = sqldatetime
dim textdate as datetime = textdate
newdate = textdate.ToShortDateString & " " & sqldate.ToShortTimeString

rick...

With the value 01/02/2012 your code returns

Conversion from string "2012-00-02 00:00:00.000" to type Date is not valid

Why is 01 coming across as 00??

Try this:

dim cmdText as String

cmdText = "UPDATE dbo.tblTableName SET DateColumnName=CONVERT(datetime, '" & txtbox.year & "/" & txtbox.month & "/" & txtbox.day & " 00:00:00" & "')"

mwmiller,

What do you mean?

   textbox.text = "01/02/2012"
   cdate(textbox1.text).tostring("yyyy-MM-dd hh:mm:ss")

This gives you: 2012-01-02 12:00:00
Is this not the format you need?



You could also use:

   cdate(textbox1.text).tostring("yyyy-MM-dd hh:mm:ss")

This will give you: 2012-01-02 12:00:00.000

*
You could also use:

   cdate(textbox1.text).tostring("yyyy-MM-dd hh:mm:ss.fff")

This will give you: 2012-01-02 12:00:00.000

Look at the error...

Conversion from string "2012-00-02 00:00:00.000" to type Date is not valid

Could you post your code?

I've tried several different ways, this is the latest. It generates the same error. When stepping though the code, the date is in the correct format. When it errors out though, it references the month as being "00"

myCommand.Connection.Open()
            myQuery2 = "UPDATE tblMembership SET PasswordExpires = '" & Convert.ToDateTime(TextBox12.Text).ToString("yyyy-MM-dd") & ")' WHERE ID = '" & Label1.Text & "'"
            myCommand.CommandText = myQuery2
            myCommand.ExecuteNonQuery()
            myConnection.Close()

Select allOpen in new window