Problems with Date_Trunc

[NateUNI]

When I run the following statement,

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

I recieve the following error:
ERROR: function date_trunc("unknown", "unknown") is not unique
HINT: Could not choose a best candidate function. You may need to add explicit type casts.

Does anyone know how to solve this problem, Thanks!!

 

[ceco]

you should not put current_timestamp in '

i.e.

DATE_TRUNC('second', current_timestamp)

 

[NateUNI]

If I take away the ( ' ) I recieve the following error:

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

 

[NateUNI]

Basically all I want to do is get the current time/date to the second, not the persision the is defaulted to current_timestamp. Could I maybe write a date format statement? Thanks!

 

[ceco]

if you did

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

I can't see why you get unterminated string ;-((

can you give an example of what is your intend, because I didn't get the idea sorry ;-(

 

[flugh]

maybe post your update_status function. it's probably just some data making it from your web-based form being posted to postgresql without being properly escaped (pg_addslashes() with php).

----
JBR