php timestamp mysqli bind_param选择喜欢

Question

How to set bind_param values for timestamp (CURRENT_TIMESTAMP ) in a

select * from mytable where date like=?

i tried it with an integer but than like is not working.

Answer 1

$date = date('Y-m-d H:i:s');
"SELECT * FROM mytable WHERE date='$date'";