Insert Now() as date

This is a real basic question. But when i'm inserting data to mysql what syntax do i use to enter todays date/time in a field in the database.

INSERT INTO test (1,2,3) VALUES ('$1','$2','now()')

in this example i want to insert the current date/time in for 3. What is the syntax?

Thank you for your help

Mark.

Remove quotes from 'now()'

INSERT INTO test (1,2,3) VALUES ('$1','$2',now())

Make sure the column / field for the insert is of type date or Timestamp

If it's a text type, you'd want to change now into a string

INSERT INTO test (1,2,3) VALUES ('$1','$2',date_format(now(),'%d %m %Y'))

or something similar