title: In what format does Oracle expect a date value, and how can I give Oracle what it wants?
body: <p>"AVAILABLEDATE" is a column of type DATE. </p>
  
  <p>I can query the table via Toad and get results. However, in (Winforms/C#/dotConnect) code, it's not working. </p>
  
  <pre><code>ocmd.Parameters.Add("AVAIL_DATE", getDateToQuery());
  </code></pre>
  
  <p>I'm pretty sure the problem is the way I'm passing the date:</p>
  
  <pre><code>private DateTime getDateToQuery() {
    DateTime candidateVal = dateTimePickerScheduleDate.Value;
    if (candidateVal.Equals(null)) {
      candidateVal = DateTime.Now;
    }
    return candidateVal;
  }
  </code></pre>
  
  <p>...but I don't know how to force the date value to be in the format Oracle will recognize.</p>