Search results for query: *

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!

I have the following query: SELECT * FROM Prospect WHERE Prospect.ID_NUMBER NOT IN ( SELECT ID_NUMBER FROM Prospect_EMAIL WHERE CAMPAIGNID=50) This query takes a LONG time to run. Is that a better way to write this query. I am using Oracle if that helps, Thanks!!

You could also use the INITCAP funtion if you database supports it

I have several (40 variables) that need to be passes when the user clicks on a A HREF tag. Is there a easy way to do this besides appending the variables onto the link? Am i missing something here? Thanks!!

Thanks, Thats exactly what I needed!

I'm running into the following problem when I try to use the array_multisort fuction. I'm trying to sort by date [1], then report name [0]. If I print out the multi-dimensional array before the array_multisort function, I recieve the following: Array ( [0] => Array ( [0] => change [1] =>...