eg.
场景,把oracle 的时间字段datetime 有原来的is not null 该为null,而引起的sql的更改,
nullif(case1,case2) 如果case1==case2 返回null(此null非php中的null或者空,是oracle的NULL),
如果case1 != case2 返回case1,
$con = Propel::getConnection('propel', Propel::CONNECTION_WRITE);
$addr = '';
$nal = '';
$sql = "insert into test set contact_id = 1728289,charging_no='55555',
charging_create_time=NULLIF('{$addr}','' ), charging_address=NULLIF('{$nvl}','' ), created_at=NOW(),updated_at=NOW()";
$que = $con->prepare($sql);
$que->execute();