Databases
StackOverflow2013
Postsdbo
POvb.net SQL date to time conversion issue
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POvb.net SQL date to time conversion issue
    primarykey
    data
    text
    <p>The error is: Conversion failed when converting date and/or time from character string.</p> <p>Basically I'm trying to make it so that when someone clicks a location in a list box it increments the correct field in a Stats table by 1 to say that they clicked the location. I've been trying to solve this for a while now and can't get anywhere. My date is in date format, and so is the Date field in my Stats table. My code can be seen below.</p> <pre><code> Dim Current As String Dim Check As String Dim objCmd2 As Object Dim iCount As Integer Dim tDate As Date Current = LocBox.SelectedItem Check = LocList.FindString(Current) If Check &gt; -1 Then MsgBox("You have already selected this place to visit") Else LocList.Items.Add(Current) ObjDataReader.Close() tDate = Date.Today MessageBox.Show(tDate) tDate = tDate.ToString() objCmd2 = New SqlCommand("SELECT " &amp; Replace(Current, " ", "_") &amp; " FROM Stats WHERE Date = '" &amp; tDate &amp; "'", objConn) ObjDataReader = objCmd2.ExecuteReader If ObjDataReader.HasRows Then ObjDataReader.Read() If ObjDataReader(0) Is DBNull.Value Then iCount = 0 Else iCount = ObjDataReader(0) End If Else iCount = 0 End If objCmd = New SqlCommand("INSERT INTO Stats(Date," &amp; Replace(Current, " ", "_") &amp; ") Values('" &amp; tDate.Date &amp; "'," &amp; iCount &amp; " )", objConn) ObjDataReader.Close() objCmd.ExecuteNonQuery() objConn.Close() </code></pre> <p>Thanks in advance.</p> <p>The issue comes in with the second SQL statement I think. I don't understand why adding a date into a date field would be an issue, I've tried adding it as a string which didn't work. Thanks for all the answers so far.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCoolmurr
    1. USCoolmurr
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COUse parameterised queries with parameters of the correct datatype. This is safer (SQL injection) and should resolve your issue.
      singulars
      1. POvb.net SQL date to time conversion issue
      1. USMartin Smith
    2. COWhat is the format of the datetime column in Sql Server? Is it actually a date time? Or is it something like varchar? You should not be using strings when dealing with dates and times. Use a DateTime.
      singulars
      1. POvb.net SQL date to time conversion issue
      1. USChris Dunaway
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload