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