[jira] [Created] (EMPIREDB-248) date functions not properly handled in PostgreSQL

[JIRA]

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)