how to bind_param SQL now() in prepared statement

[Markus Krebs]

Hi all,

i have a question regarding the use of the SQL function now() with prepared Statements via DBD::mysql:

i use to prepare queries this way:

$STH=$DBH->prepare("update table set a=?,b=?,c=? where id=?");

and bind the values:

$STH->bind_param(1,$value1,{TYPE=>SQL_INT});
...

and so on.

Now here is what i want to do:

Suppose "a" is a datetime column.
How can i bind the parameter "now()" to this column in a prepared statement, so the scalar "now()" wont get quoted by DBI?
Which SQL_TYPE should i use with DBI::bind_param()?

Sometimes the value is a datetime string (SQL_CHAR), sometimes it will be the current datetime (SQL now()).

Can someone give me a hint on this problem, please?

Regards,
makro