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