title: How to save date in ORACLE in Y-m-d H:i:s format?
body: <p>In PHP, <code>date('Y-m-d H:i:s')</code> gives result like <code>'2017-02-17 23:10:00'</code> format.</p>
  
  <p>Now, I want to save the result in <strong>ORACLE 10g</strong>. I am using <strong>Oracle 10g Xpress Edition</strong>.</p>
  
  <p>Now, I am trying to save the Data like this.</p>
  
  <pre><code>$sql = "INSERT INTO tbl_language VALUES 
  (1, 'Hindi', TO_DATE('".$time."','yyyy-mm-dd hh24:mi:ss'))"; 
  </code></pre>
  
  <p>Where <code>$time = date('Y-m-d H:i:s');</code></p>
  
  <p>The date value is getting saved as <code>12-Feb-17</code>.
  How can I get the date data saved in the desired form?</p>