title: vb.net convert dd MMM yyyy to Date
body: <p>I have tree view with selected value as Date with format <code>DD MON YYYY</code>.</p>
  
  <p>Now I want to Convert it into date and insert into oracle Database table.</p>
  
  <p>Problem is that when i insert it into DB it Show Like this if date is <code>15 AUG 2013</code> and when inserted into db it shows like this <code>8/20/0015 1:00:00 PM</code>.</p>
  
  <p>But I don't want this wrong value.I want to insert exact date format.</p>
  
  <p>Here is My Code through which i am inserting into DB:</p>
  
  <pre><code>Dim dte As String = TreeView1.SelectedValue
  
  Dim cmmd As OleDbCommand = New OleDbCommand("select count(*) from DIR_CHQAPP_SR where APP_DTE = '" &amp; dte &amp; "' and sta_flg=" &amp; flg &amp; "", con)
  Dim no As Integer = cmmd.ExecuteScalar()
  If no &lt; 1 Then
      cmmd.CommandText = "insert into DIR_CHQAPP_SR (APP_DTE, APP_NO,STA_FLG) values ('" &amp; dte &amp; "',1," &amp; flg &amp; ")"
  Else
      cmmd.CommandText = "update DIR_CHQAPP_SR set app_no = nvl(app_no,0)+1 where APP_DTE = '" &amp; dte &amp; "' and sta_flg = " &amp; flg &amp; ""
  End If
  cmmd.ExecuteNonQuery()
  con.Close()
  </code></pre>