i m inserting time from listview into sql database 2005.....but it results inserting both date and time part as well..but i want to insert only the time part...my code is below...thanks...plzz help


Code:
 Dim conn As New SqlConnection("server=localhost;database=attendance1;uid=sa;password=;")
        Dim i As Integer

        For i = 0 To ListView1.Items.Count - 1
            Dim cmd As New SqlCommand


            cmd.Connection = conn
            cmd.CommandText = "INSERT INTO shift (shift_name,on_duty_time,off_duty_time,beginning_in,ending_in,beginning_out,ending_out) VALUES (@shift_name,@on_duty_time,@off_duty_time,@beginning_in,@ending_in,@beginning_out,@ending_out) "
            cmd.CommandType = CommandType.Text
            cmd.Parameters.AddWithValue("@shift_name", ListView1.Items(i).SubItems(0).Text)
            cmd.Parameters.AddWithValue("@on_duty_time", Convert.ToDateTime(ListView1.Items(i).SubItems(1).Text))
            cmd.Parameters.AddWithValue("@off_duty_time", Convert.ToDateTime(ListView1.Items(i).SubItems(2).Text))
            cmd.Parameters.AddWithValue("@beginning_in", Convert.ToDateTime(ListView1.Items(i).SubItems(3).Text))
            cmd.Parameters.AddWithValue("@ending_in", Convert.ToDateTime(ListView1.Items(i).SubItems(4).Text))
            cmd.Parameters.AddWithValue("@beginning_out", Convert.ToDateTime(ListView1.Items(i).SubItems(5).Text))

            cmd.Parameters.AddWithValue("@ending_out", Convert.ToDateTime(ListView1.Items(i).SubItems(6).Text))

            conn.Open()
            cmd.ExecuteNonQuery()
            conn.Close()
        Next i
        ListView1.View = View.Details
        MsgBox("ok")