title: Oracle Date Time Concatenation
body: <p>I have 2 form fields - one captures the date in DD-MON-YY format and one form field that captures the time in HHMM (no colon) format - 24 hour.</p>
  
  <p>I am trying to concatenate these and insert them into an Oracle Date/Time field</p>
  
  <pre><code>$sql = "INSERT INTO SCHEMA_A.MOVIES(MOVIEDATE) VALUES to_date(:dt||:tm, 'DD-MON-YY HH24MI');
  
  $compiled = oci_parse($con, $sql);
  
  oci_bind_by_name($compiled, ':dt', $f1); //date
  oci_bind_by_name($compiled, ':tm', $f2); //time
  
  oci_execute($compiled);
  </code></pre>
  
  <p>Am I doing this correctly? </p>
  
  <p>and to retrieve the time... (and I will be doing some math with these time values as well)</p>
  
  <pre><code> $sql = "SELECT to_char(MOVIEDATE, 'HH24MI') as MTIME FROM SCHEMA_A.TABLE_A... 
  </code></pre>
  
  <p>and to retrieve just the date ...</p>
  
  <pre><code>$sql = "SELECT to_char(MOVIEDATE, 'DD-MON-YY') as MDATE FROM SCHEMA_A.TABLE_A... 
  </code></pre>
  
  <p>just wondering if this is correct ??</p>