Dear Alberto, thank you very much for letting us know.
The correct procedure for bugs and improvements like this, is to create an issue in our JIRA ticketing system. I have now done this for you, but you might as well do it yourself next time. Here's the issue: https://issues.apache.org/jira/browse/EMPIREDB-248 I will also take your suggestion and modify the PostgreSQ database driver. Thanks again, Rainer De: Alberto Osvaldo Gonzalez Enviado el: viernes, 28 de octubre de 2016 15:23 Para: '[email protected]' <[email protected]<mailto:[email protected]>> Asunto: Fix on PostgreSQLDriver 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 ?)"; I do not know if there's a way I can fix the code on a branch or sth. If there is way just tell me and i'll do it. I'm not very familiar with git but i think i can manage. Thanks in advance. Alberto
