title: Oracle DateTime to C# Date time
body: <p>I am returning utc date time from my stored procedure, like this</p>
  
  <pre><code> SELECT CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) INTO utc_date FROM DUAL;
  </code></pre>
  
  <p>I am returning it in Out parameter of my sp, the out parameter type is TimeStamp, since I want time as well.
  This is how I am getting the returned parameter from sp </p>
  
  <pre><code> DbParameter param25 = GetDbParameter("my_utc_date" , DbType.DateTime2 , DBNull.Value);
                              param25.Direction = ParameterDirection.Output;
                              param25.Size = 100;
                              cmd.Parameters.Add(param25);     
  </code></pre>
  
  <p>now I want to convert the value of param25 to date time, I tried this,but its giving me format exception "String was not recognized as a valid DateTime."</p>
  
  <pre><code>  DateTime.ParseExact(Convert.ToString(param25.Value), "d/M/yyyy" , System.Globalization.CultureInfo.GetCultureInfo("en-US"));
  </code></pre>
  
  <p>I tried using DbType.DateTime too, but same error.</p>
  
  <p>I am getting this value in param.Value, </p>
  
  <pre><code>17-OCT-17 07.07.35.000000 AM
  </code></pre>
  
  <p>How can I convert oracle datetime to c# datetime,with time as well.</p>