insert a time-stamp value in my db by php

Posted by Erick on Stack Overflow See other posts from Stack Overflow or by Erick
Published on 2010-06-15T14:42:06Z Indexed on 2010/06/15 14:52 UTC
Read the original article Hit count: 220

Filed under:
|
|

I'm using oracle express and in my application i would insert a time-stamp value in my table:

$marca = date('y-m-d H:i:s');

    $query = "  INSERT INTO SA_VERSIONE
                    ( ID_ACCETTAZIONE, MARCA_TEMPORALE, TESTO, FIRMA, MEDICO)
                    VALUES
                    ('$id', '$marca', '$testo', '$firma', '$medico')
        ";

        $stid = oci_parse($conn, $query);

        oci_execute($stid);

but when execute it return:

Warning: oci_execute() [function.oci-execute]: ORA-01843: mese non valido in ... and say that the month is not valid

© Stack Overflow or respective owner

Related posts about php

Related posts about sql