php - "Syntax error or access violation" when inserting dates using PDO and SQL Server -

i trying add 2 simple strings , 1 date sql server using pdo in php. i'm using following code so:

$data = array(     'omschrijving' => 'mijn mooie omschrijving...',     'toelichting' => 'mijn leuke toelichting...' );  # insert data $sth = $dbh->prepare("insert memo (datum, omschrijving, toelichting) values (now(), :omschrijving, :toelichting)"); $sth->execute($data); 

it works without date, reason gives me following error when try add date:

sqlstate[42000]: syntax error or access violation: 8180 [freetds][sql server]statement(s) not prepared. (sqlexecute[8180] @ /builddir/build/build/php-5.6.9/ext/pdo_odbc/odbc_stmt.c:254)

does know i'm doing wrong?

thanks in advance!

now() mysql function. getdate() sql-server's equivalent. here's documentation on function, https://msdn.microsoft.com/en-us/library/ms188383.aspx.

so provided code should become:

$data = array(     'omschrijving' => 'mijn mooie omschrijving...',     'toelichting' => 'mijn leuke toelichting...' );  # insert data $sth = $dbh->prepare("insert memo (datum, omschrijving, toelichting) values (getdate(), :omschrijving, :toelichting)"); $sth->execute($data);