You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Rainer Döbele (JIRA)" <em...@incubator.apache.org> on 2016/10/29 11:08:58 UTC
[jira] [Created] (EMPIREDB-248) date functions not properly handled
in PostgreSQL
Rainer Döbele created EMPIREDB-248:
--------------------------------------
Summary: date functions not properly handled in PostgreSQL
Key: EMPIREDB-248
URL: https://issues.apache.org/jira/browse/EMPIREDB-248
Project: Empire-DB
Issue Type: Bug
Components: Core
Reporter: Rainer Döbele
Assignee: Rainer Döbele
Fix For: empire-db-2.4.5
Alberto Osvaldo Gonzalez reported:
Hi, this is Alberto from Argentina. I’m using empire-db and found an issue using postgresqldriver.
The problem appears when using the “year” function to extract the year from a date.
This is the original source code:
(line 347)
case SQL_FUNC_DAY: return "day(?)";
case SQL_FUNC_MONTH: return "month(?)";
case SQL_FUNC_YEAR: return "year(?)";
And this is what i modified:
(line 347)
case SQL_FUNC_DAY: return "extract(day from ?)";
case SQL_FUNC_MONTH: return "extract(month from ?)";
case SQL_FUNC_YEAR: return "extract(year from ?)";
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)