DB: Inserting a value into an Oracle DATE column with autoPrepare/execute()
| From: | Shawn Coomey | Date: | Tue, 30 Dec 2003 18:14:16 +0000 |
| Subject: | DB: Inserting a value into an Oracle DATE column with autoPrepare/execute() | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-9881@lists.php.net to get a copy of this message | ||
Hi folks-
I am trying to insert a date (comes from a $_POST var in the form of
mm/dd/yyyy) into an Oracle table's date column. How can I do this with PEAR?
I am trying this currently, but get a "[nativecode=ORA-01843: not a valid
month]" error:
/************ Code Example *************/
$table_fields = array("DOC_ID", "CC_MEETING_DATE");
$table_values = array($doc_id, $_POST["cc_meeting_date"]);
$table_name = "my_table";
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
$inserter = $db->execute($sth, $table_values);
/******** End Code Example **********/
Thanks!
Shawn