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 do...@apache.org on 2016/10/29 11:27:21 UTC

empire-db git commit: EMPIREDB-248 Submitted fix provided by Alberto Osvaldo Gonzalez

Repository: empire-db
Updated Branches:
  refs/heads/master 386368c91 -> 325e4223c


EMPIREDB-248
Submitted fix provided by Alberto Osvaldo Gonzalez 

Project: http://git-wip-us.apache.org/repos/asf/empire-db/repo
Commit: http://git-wip-us.apache.org/repos/asf/empire-db/commit/325e4223
Tree: http://git-wip-us.apache.org/repos/asf/empire-db/tree/325e4223
Diff: http://git-wip-us.apache.org/repos/asf/empire-db/diff/325e4223

Branch: refs/heads/master
Commit: 325e4223c0539e5e607109a078ef9004522a031d
Parents: 386368c
Author: Rainer D�bele <do...@esteam.de>
Authored: Sat Oct 29 13:27:12 2016 +0200
Committer: Rainer D�bele <do...@esteam.de>
Committed: Sat Oct 29 13:27:12 2016 +0200

----------------------------------------------------------------------
 .../empire/db/postgresql/DBDatabaseDriverPostgreSQL.java       | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/empire-db/blob/325e4223/empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java
----------------------------------------------------------------------
diff --git a/empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java b/empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java
index 5965dc7..21024e8 100644
--- a/empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java
+++ b/empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java
@@ -361,9 +361,9 @@ public class DBDatabaseDriverPostgreSQL extends DBDatabaseDriver
             case SQL_FUNC_FLOOR:              return "floor(?)";
             case SQL_FUNC_MODULO:             return "mod(?,{0})";
             // Date
-            case SQL_FUNC_DAY:                return "day(?)";
-            case SQL_FUNC_MONTH:              return "month(?)";
-            case SQL_FUNC_YEAR:               return "year(?)";
+			case SQL_FUNC_DAY:                return "extract(day from ?)";
+			case SQL_FUNC_MONTH:              return "extract(month from ?)";
+			case SQL_FUNC_YEAR:               return "extract(year from ?)";
             // Aggregation
             case SQL_FUNC_SUM:                return "sum(?)";
             case SQL_FUNC_MAX:                return "max(?)";