On Fri, 9 Mar 2001, John K. Lien wrote:
..
> I'd like to turn something like this:
> $statement = "UPDATE emp SET hiredate = sysdate WHERE empno = ?";
>
> into something like this:
> $statement = "UPDATE emp SET hiredate = ? WHERE empno = ?";
$statement = "UPDATE emp SET hiredate =
TO_DATE('YYYY-MM-DD HH24:MI:SS', ?) WHERE empno = ?";
i discovered this in an annoying manner.. oracle 8.0 does not require to
cast a date-string to a date (via TO_DATE) it's done implicitly but the 8i
client requires it. :(
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> POTS Phone: +63 (2) 848-2893
Mosaic Communications, Inc. GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying every minute of it!!
