Recent content by 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!

If I take away the ( ' ) I recieve the following error: ERROR: unterminated string CONTEXT: compile of PL/pgSQL function "update_status" near line 3

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...

I want the following trigger to update a related table when ever a record is inserted/updated. I have the following trigger: CREATE TRIGGER update_status AFTER INSERT OR UPDATE ON public."Bug Status" FOR EACH ROW EXECUTE PROCEDURE public.update_status(); Which Calls this function...

Ok, im running a similar statment. I want to append onto a string that is stored in a blob. This is what I currently have DECLARE v_QUERY CHAR; CURSOR c IS SELECT QUERY FROM MESSAGECONFIG where campaignid = 1902 FOR UPDATE; BEGIN FOR i IN c LOOP v_QUERY:=...

select * from bugtracking where DateValue([Reported Date]) = #01/04/2004#

No, I'm just running the query in Access, Thanks Nate

The query, select * from bugtracking works fine, returns 50,000 rows The query, select * from bugtracking where DateValue([Reported Date]) = #01/04/2004# Does not work, I recieved this error: Data type mismatch in criteria expression The Reported Date field is a type Date/Time with General...

When I run the following: select * from bugtracking where DateValue([Reported Date]) = #01-04-2004# I recieve the following error: Data type mismatch in criteria expression Any suggestions? Thanks!

Thanks for the replys! However, when I run this query, select * from bugtracking WHERE CDate(format([Reported Date],"mm/dd/yyyy")) = #01/04/2004# I recieve the following error: Data Type Mismatch in Criteria Expression [Reported Date] is a Date/Time field. So when you convert it...

I have the following query, select * from bugtracking where Format([Reported Date],"mm-dd-yyyy") = #01-04-2004# however it does not pull any records, even though there are records for those dates (ie, 1/4/2004 12:29:30 AM) What am I doing wrong with this query, Thanks!

I tried this, SELECT DateValue([Reported Date]) AS ReportedDate, BugTracking.[Tracking Number] FROM BugTracking WHERE (((BugTracking.[Reported Date]) = #12/15/2003#)); and it does not bring back any rows, any other ideas, Thanks!!

Im trying to do a easy query, SELECT BugTracking.[Reported Date] FROM BugTracking WHERE (((BugTracking.[Reported Date]) Like #12/15/2003#)); which returns 0 records, however the Reported Date field in the database is a type date/time so if i do this query: SELECT BugTracking.[Reported Date]...

I am working with a Access Database and when I run the following code, it returns all records, instead of just the first 20. <?php //Connection statement require_once('Connections/STATS.php'); // begin Recordset $maxRows_Recordset1 = 20; $pageNum_Recordset1 = 0; if...

How about if I have fields in the first select that are not in the second select? Thanks!