如何在oci_bind_by_name函数中传递sysdate来更新记录？

Question

如何使用oci_bind_by_name函数传递oracle表中的sysdate to date列

例如

$upquery = "UPDATE mytable SET fieldA = :b_ssn, fieldUpdated = :b_updateDate where fieldKey = :b_key";
$whatsup = oci_parse($conn, $upquery);
oci_bind_by_name($whatsup, ':b_ssn', $the_ssn, -1, OCI_B_INT);

oci_bind_by_name($whatsup, ':b_updateDate, sysdate, ... ? // <--

oci_bind_by_name($whatsup, ':b_key', $the_key, -1, OCI_B_INT);
oci_execute($whatsup);

我该如何传递它？

忽略这个...为什么不在查询LOL中使用sysdate

Answer 1

如下所示：

$upquery = "UPDATE mytable SET fieldA = :b_ssn, fieldUpdated = SYSDATE where fieldKey = :b_key";

我不熟悉php，也许这个也能用：

oci_bind_by_name($whatsup, ':b_updateDate', new DateTime(), SQLT_ODT)