Truncating 'now' to seconds - Mailing list pgsql-general

I am trying to run the following query:

INSERT INTO public."Bug Status" ("Tracking Number", "Assigned Analyst",
status, "Changed By", "Updated Date") VALUES
(111111111, 'NS', 'Reported', 'NS', DATE_TRUNC('second', 'now'));

I recieve the following error:

ERROR:  unterminated string
CONTEXT:  compile of PL/pgSQL function "update_status" near line 3

I am basically wanting to truncate the timestamp to seconds, so that I
don't get milliseconds.  Does anyone know what I am doing wrong?  Thanks