Hi!
I have a form with 2 textboxes. One for date and the other for time.
How I save the time in my sql database in a field type datetime?
Here is my code:

Dim xDate As Date
Dim xTime As DateTime
xTime = txt_time.Text
xDate = txt_date.Text
Dim cmd_log As New SqlClient.SqlCommand("INSERT INTO MyTable (fld_date,fld_time) VALUES (@date,@time);", conn_log)
cmd_log.Parameters.AddWithValue("@date", Format(xDate, "yyyyMMdd"))
cmd_log.Parameters.AddWithValue("@time", xTime)
        conn_log.Open()

Do I have to format my variable xTime like I did for variable xDate?
Thanks :).

I don't want to just sound critical right up front, but it's usually much easier to deal with storage of a date and time in a database with a single datetime field. Then you can just insert and deal with a single value.

With a single field you could use something like this to create a strongly typed datetime value from the two input strings:

DateTime.Parse("{0} {1}", date, time)

Using the date and time separately in two values requires more manual formatting.

-Peter

Hi planoie! Thanks for the help!
I modified my code with your sugestion, and it works fine!