[dba-issues] [Issue 103425] Query parser does not rec ognize MySQL version of datediff
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103425 User oj changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Target milestone|--- |OOo 3.4 --- Additional comments from o...@openoffice.org Thu Dec 2 13:38:37 + 2010 --- Now we support DATEDIFF also with 2 arguments. Grabbing - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 103425] Query parser does not rec ognize MySQL version of datediff
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103425 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Thu Dec 2 13:39:22 + 2010 --- Fixed in cws dba34c. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 103425] Query parser does not rec ognize MySQL version of datediff
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103425 Issue #|103425 Summary|Query parser does not recognize MySQL version of dated |iff Component|Database access Version|OOO310m14 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from atjen...@openoffice.org Wed Jul 8 22:00:13 + 2009 --- The query parser for OO.o currently only supports a datediff function with 3 parameters: datediff( string, date1, date2 ) Where string allows for setting the type of return value: days, hours, seconds, etc. MySQL however only supports a datediff with 2 parameters, datediff(date1, date2) and always returns days. So the datediff function requires that escape processing be turned off, and may not be used in the Query Deisgner at all. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org