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:28:58 UTC
[jira] [Resolved] (EMPIREDB-248) date functions not properly
handled in PostgreSQL
[ https://issues.apache.org/jira/browse/EMPIREDB-248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele resolved EMPIREDB-248.
------------------------------------
Resolution: Fixed
Patch submitted by Alberto Osvaldo Gonzalez.
> 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)