empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele (JIRA) <empire-db-...@incubator.apache.org>
Subject [jira] [Closed] (EMPIREDB-248) date functions not properly handled in PostgreSQL
Date Wed, 09 Nov 2016 08:03:58 GMT

     [ https://issues.apache.org/jira/browse/EMPIREDB-248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rainer Döbele closed EMPIREDB-248.
----------------------------------

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

Mime
View raw message